| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF w/multiple conditions
Here's my current formula:
=SUMIF(A3:A50,"Consumer",J3:J50)/C55 This works fine to get an average sum for everything that reads Consumer, but now I need to sum only the positive $ amounts in column "J3:J50". How and where do I insert this extra condition? Any help would be appreciate. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif for multiple conditions | Excel Worksheet Functions | |||
| sumif with multiple conditions | Excel Worksheet Functions | |||
| Using SumIf and Multiple Conditions | Excel Discussion (Misc queries) | |||
| SUMIF with Multiple Conditions | Excel Worksheet Functions | |||
| sumif - multiple conditions | Excel Worksheet Functions | |||
Threaded Mode
