Discussion Locked
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
Poster rated this answer
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.
by samloe
Point value changed by question poster.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
Question Unanswered
Best Low-Latency VPN Protocols for Competitive Mobile and Online Gaming
0 helpful
0 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies