Hello all,
I am looking for a kind of Sumif function to sum the values in column A if
the conditions in column B are OK. BUT the range should be limited. Sumif
sums all the values in the range which match a condition, while I am looking
for some function which limits the range (as specified). In the example
below, when you drop down from C1, the values from column A should be summed
in column C once you reach the first '1' for all B's=0, but only for the
previous 'block' of zeros. I hope the example makes it a bit more clear.
A B C
0,1 0 0
0,1 0 0
0,1 0 0
0,1 1 0,3 (=sum A1-A3)
0,1 1 0
0,1 1 0
0,1 0 0
0,1 0 0
0,1 0 0
0,1 0 0
0,1 1 0,4 (=sum A7-A10)
....
thanks!
Maarten