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".

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".