Join the most popular community of UK swingers now

Can any one help

last reply

22 Oct 2004

7 replies

549 views

0 watchers

0 likes

22 Oct 2004

I am trying to set set up a personal finance data base on works 2000 spreadsheet.
How do i get a running total for each line, at the moment only the fisrt line calculates.
Right now i have =B1+C1+D1+E1. F1 being total
THX Keith & Mia

22 Oct 2004

OK, best way to do this is with the SUM command.
In cell F1 enter this:
=SUM(B1:E1)
Oh, and can some kind mod move this to the correct forum?

22 Oct 2004

Edit: lol, beat me to it lol

22 Oct 2004

OR use the funny looking E to drag all needed cells into a sum - as long as they are in a line (either row or column). Just click on the funny looking E and then click and drag down your row or column until just next to the total cell and press enter.

22 Oct 2004

.......and once you have done as suggested above - if you need the same calculation for rows 2,3,4,5.......
You can just 'copy' F1 to f2,f3, etc.
Excel will copy the formula rather than the cell contents, unless you state otherwise.
Alex x

22 Oct 2004

Or Highlight the block and CTRL+D to copy down or CTRL R to copy right.

22 Oct 2004

Or just give up and stare at Alexandras avatar pic all day :shock:

22 Oct 2004

I do that anyway ;)