Lucy has attended:
Excel Advanced course
Tables in Excel
Is there a formula that i can use in an excel spreadsheet that will add a sum to a total creating a new total, which when you add a new sum, will add to the new total creating the next new total? As an example, if you are working out expenses on a monthly basis, but want to total the monthly expense to an added running total- i would like to know how i can create this running total.
Hope that makes sense! Thanks
RE: tables in Excel
Hi Lucy, not sure whether I'm getting the wrong end of the stick here, but you just want to create a sum formula that keeps updating itself when more is added to the range?
if you have a column of figures in column A and a total of that column in, say, A100 then the same for column B, then column C etc,
try doing a fomula similar to this:
=sum(A100:IV100) this will sum up all of your totals in row 100.
Where is your grand total figure going to be located?
Paul
