Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
|
|||
|
|||
Claus Busch
many thanks .. it was a smart one .. best regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy one column values to another column based on conditionthat row2 contain todays date | Excel Programming | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
macro to transpose cells in Column B based on unique values in Column A | Excel Programming | |||
Calculating values to column D with formula based on values column A | Excel Programming |