| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract two columns, but only for cells identified by if statemen
I have 3 columns of information, A, B, C. C is defined by an if statement
if(B<A,"yes", ""). Now I would like to find the difference between A & B, for all the cells in the column that received a "yes" and add to one total. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can cells containing linked formulas be identified? | Excel Worksheet Functions | |||
| Can cells containing linked formulas be identified? | Excel Discussion (Misc queries) | |||
| Is there a way to change text color using the Logical IF statemen. | Excel Worksheet Functions | |||
| How do I use a cell as a referance to a file in a lookup statemen. | Excel Worksheet Functions | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
