N
Neutron1871
I am trying to sum values in Row N where the following two conditions are met:
1) N2:N278 > 0
2) P2278 = 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".
1) N2:N278 > 0
2) P2278 = 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".