Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
101
Views
Topic starter
The attached example w/book illustrates my query - you have a year column, and 'amounts' adjacent to them (column B). I want to do a running (cumulative) total for each year group - see amounts in column E. Column C is just a running total ignoring the year and column D is my attempt at what I want but I can't get it to work ...
What's the trick?
Posted : 30/07/2019 10:49 pm
You are close:
=SUMIF($A$2:$A2,A2,$B$2:B2)
Posted : 30/07/2019 11:33 pm
Topic starter
Thanks mate, you're a champ!
Posted : 30/07/2019 11:43 pm
