| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with two conditions
I am trying to sum values in Row N where the following two conditions are met:
1) N2:N278 0 2) P2:P278 = 0 Here is what I have so far =SUMPRODUCT(--($N$2:$N$2780),--($P$2:$P$278="0"),(N2:N278)) Please help the above formula returns a "0". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF with two conditions
Nevermind, i figured it out. I had "" around my 0.
"Neutron1871" wrote: I am trying to sum values in Row N where the following two conditions are met: 1) N2:N278 0 2) P2:P278 = 0 Here is what I have so far =SUMPRODUCT(--($N$2:$N$2780),--($P$2:$P$278="0"),(N2:N278)) Please help the above formula returns a "0". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif with two conditions? | Excel Worksheet Functions | |||
| Sumif with 2 conditions | Excel Discussion (Misc queries) | |||
| SUMIF with two conditions? | Excel Worksheet Functions | |||
| SUMIF 2 conditions are met??? | Excel Worksheet Functions | |||
| sumif with 2 conditions ?? can this be done?? | Excel Worksheet Functions | |||
Hybrid Mode
