Simple...but not so Simple..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

trying to set up a simple spreatsheet in Office 2003 Excel.
Columns A, B, C, D are client information. Column E is an invoice
amount. I want column F to be the running total of all the column
E amounts. So each time I put a number in E, it will add that to
the total in F and give me a total amount received.

I have tried and tried and cannot get this to happen. Seems
like it should be a simple process, but I have had no formula
that comes close to working.

Help, please

TK
 
suggest you re-post your question to an Excel newsgroup. this NG answers
questions about MS Access relational database software.
 
Try setting F1 = E1 (your first value)
Then F2 = F1+ E2 (cumalative total + next invoice)
Each time you add an invoice you should be able to fill down the
formula to get you new running total in col. F.
 
formula in F2 which is then copied down rest of column

=Sum($E$2:$E3)

$ makes it stay that number/letter
Assums title in cell E1
 
Back
Top