Cumulative Total By Month

Hi,

I have a list of daily sales which I would like to have a cumulative total by month. Once the next month is encountered, the cumulative total will reset for that month again.

E.g. (please see attached file)
Column C is my cumulative total. The cumulative sum will reset when the month changes from Jan to Feb.

I can achieve the results using VBA but I need to distribute my report to parties whose VBA environment is disabled. So, I need to work around this with a formula.

Regards.

Re: Cumulative Total By Month

Hi Bob,

Thank you. It was a nice one!

Regards.

Re: Cumulative Total By Month

Hi Dave,

Would it be too troublesome for you to show me how can I achieve it with a pivot table?

Regards.

Re: Cumulative Total By Month

Hi Dave,

As much as i would like to, I'm afriad I can't. I have to protect my company's interests.

Bob's solution worked just fine. (Thanks again, Bob!)

Re: Cumulative Total By Month

Hi PCI,

Thank you. Got me curious where the field "month" came from but I guess that is another question to start a new thread.

Regards.

Re: Cumulative Total By Month

Hi PCI,

Thank you very much!