Sum of values in column A based on 0/1 of column B

[Wael2029]

Dear all,

I have 3 columns column A "gain" which is the amount of money (e.g.
230), column B is "condition" it is either 0 = success or 1 = failur
and column C is "total sum".
With each new row the total sum will calculate the gain with tha
formula =SUM($A$2:A2).

All I need is to start again when column C = 1. So, how to make formul
in column C check the 0/1 in column B and start the summation from th
next value in column

 

[Claus Busch]

Hi,

Am Mon, 24 Sep 2012 17:24:10 +0000 schrieb Wael2029:

I have 3 columns column A "gain" which is the amount of money (e.g.,
230), column B is "condition" it is either 0 = success or 1 = failure
and column C is "total sum".
With each new row the total sum will calculate the gain with that
formula =SUM($A$2:A2).

All I need is to start again when column C = 1. So, how to make formula
in column C check the 0/1 in column B and start the summation from the
next value in column A

in C2:
=A2
in C3:
=(B3=0)*C2+A3 and drag down


Regards
Claus Busch

 

[Wael2029]

Claus Busch

many thanks .. it was a smart one .. best regard