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

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 = 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

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

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Claus Busch

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