Forum Discussion
Cumulative total
How can I get formulated cumulative total on a monthly basis in column H and I by adding daily value in column C and D Attached file for reference
I believe what you're looking for is simpler than is being described here.
I like the arrangement of your data. You're keeping everything on 1 sheet which makes analysis easy. Don't give into the temptation of moving next month's records to its own sheet. Excel can handle everything in 1 sheet.
Attached is your data converted to a Table with a dedicated Totals row. The Totals row can be shown/hidden by clicking a check box. When you're ready to add new data turn off the totals row. When you need the totals, check the box to show it again.