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
|