View Single Post
 
Old 03-02-2015, 01:20 PM
Chancy Chancy is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
You can do running totals, but I'm not sure how to get them to do what you want. But try them out and see where you get.

* Right-click one of the cells in the values area
* Select Show Values As >
* Select Running Total In...
* Choose from the field list
* Click OK

Let me know if you figure anything out. I couldn't make it do anything that was meaningful to my eye with your data.
Thank you gebobs, and you are right, that didn't produce meaningful results. Honestly the values that resulted made no sense to me. I take it that method replaces the existing values with something else. I don't want to replace anything, I need the original values to stay as they are. Then I need one new column that shows a running cumulative total from row to row.

I don't understand how Excel can do any running total, I've never seen it work. Would be very curious if someone has an example where the original values aren't altered?

I suspect it's not possible because the method - a calculated field? (I've struggled with them and not come up with anything) - practically speaking, has to add the value from one row to a calculated value from the row above. Where the formula on every row is different from the formula on every row above and below. How could that even be possible in Excel.

Yet, lots of experts claim this can be done. So I would like to not give up yet. Show me please!
Reply With Quote