Seems like a confusing description. Here's what I want to accomplish.

A B
-------
1 | 3 3
|
2 | 5 8
|
3 | 0 0
|
4 | 4 4
|
5 | 2 6
|
6 | 1 7

What I want to do is sum the series of column A (looking 'upward') until
a zero value is met. Then the sums start over.

In actual use, I am only looking at the past 7 or 14 days (two separate
columns)

It seems to me that this could be done by nesting IF functions.

Perhaps there is a better approach?

Thanks to all.