| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple if conditions - use sumif/sumProduct?
Joel wrote:
rirst you shouldn't have a plus sign in the formula it should be another asterisk. from =SUM(IF(($M1189:$M1316="exp")*($E1189:$E1316="D")+ ($E1189:$E1316="M"),$F1189:$F1316)) to =SUM(IF(($M1189:$M1316="exp")*($E1189:$E1316="D")* $E1189:$E1316="M"),$F1189:$F1316)) Sure? ($E1189:$E1316="D")*$E1189:$E1316="M" imposes mutually exclusive conditions that will always be FALSE. The OP stated column E could contain "D" OR "M". Nevermind the unmatched parens. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF w/multiple conditions | Excel Discussion (Misc queries) | |||
| sumif or sumproduct multiple conditions | Excel Discussion (Misc queries) | |||
| Multiple Sumif conditions | Excel Worksheet Functions | |||
| sumif with multiple conditions | Excel Worksheet Functions | |||
| SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
Threaded Mode
