SUMIF with two conditions

N

Neutron1871

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$278>0),--($P$2:$P$278="0"),(N2:N278))

Please help the above formula returns a "0".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top