Sum formula + reset

[jameslkh]

Hi All,

I wanted to have a formula to calculate the sum of a row of numbers and when there is a zero in the row the sum of no will reset and start to sum up the rest of the following number after the 0. The reflected ans will be display under the month column. Thanks you very much

Month 01-Apr 02-Apr 03-Apr 04-Apr 05-Apr 06-Apr 07-Apr 08-Apr 09-Apr 10-Apr 11-Apr 12-Apr
36 1 7 10 5 0 1 0 0 4 3 5



Regard
James Lim

[David A Coop]

James,

Under Rule 1 of the forum rules, I should not respond to this post. The title is not descriptive enough!

You will probable get asked to edit the title and repost.

When you do, please say where you want the formula, and what the answer should be for the scenario you posted.

Regards,

David