Hi,
I want to find the column C (cumulative sum of each category) to be automatically calculated. Is it possible?
e.g.
Column A Boys Boys Girls Girls Girls
Column B 2 3 4 3 2
Column C 2 5 4 7 9
Tnx!
Hi,
I want to find the column C (cumulative sum of each category) to be automatically calculated. Is it possible?
e.g.
Column A Boys Boys Girls Girls Girls
Column B 2 3 4 3 2
Column C 2 5 4 7 9
Tnx!
Using your posted example, with the data in A2:B6
This regular formula, copied down, begins the listing of cumulative totals by category:
These are the results:Please Login or Register to view this content.
Is that something you can work with?Please Login or Register to view this content.
Excellent Ron....Great job... That was too fast.....
Glad you got something you can use!
If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)
...BTW: If anybody is ever particularly helpful, you can thank them by clicking the "Add Reputation" star under one of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks