Discussion Locked

Running Total in Excel

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way, other than VBA code, to keep a running total of a cell in another cell?

6 replies

by leckie

COMMENT: Really need more
information to answer this question for
you - running total of exactly what?

by samloe

The application is an inventory spreadsheet. It calculates the cost of an order. The user wants a running total of the cost of orders during the month. Clear, I hope??

by purple713

There is a way. Go to the end of the cell that you want to calculate (Leaving room to add more numbers). Click on the SUM icon (looks like a Greek Letter). A formula will be entered in the cell. Hit enter and the total will appear.

Hope thishelps.

by bsaitomanago

I'm not sure I understand your question, but, I hope this helps. Example: Column A, Rows 1 thru 4. A1=1, A2=1, A3=1, A4=1. Place your cursor in A5 and use the sum function icon to sum that column. A5 should equal 4. If you use cell E5 as the runningtotal cell, place your cursor in cell E5 and enter =A5. Thus, everytime the values in A1 thru A4 change, the sum in A5 will change, and E5 will automatically get updated.

This discussion is closed to new replies.