Formula help.

[dasborg]

Hi.

I would some help on the following formula.


A1 B1
1 1
2 3
1 4
5 9
11 20
0 0
1 1

The idea is that column A1 adds up all of column A1 until it encounters a 0(zero). Then the b column cell will reset to zero then start adding again.

Any help would be useful.

With Compliments