| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to SUM on a condition?
I have two columns A & B which are filled with x rows of numbers.
I have a cell C1 where I show a Total which should basically SUM up the values in the two columns but there's one special conidtion: if the value in column A is 0, I only want the sum to use that value, otherwise use the value in column B. How can I do this using just excel functions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a few condition | Excel Worksheet Functions | |||
| if condition | Excel Worksheet Functions | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
| Condition 1 overules condition 2? | Excel Worksheet Functions | |||
Threaded Mode
