Simple...but not so Simple..

T

TKinHawaii

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
 
T

tina

suggest you re-post your question to an Excel newsgroup. this NG answers
questions about MS Access relational database software.
 
J

john.wynd

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.
 
R

Ron2005

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
 
Top