Sum if formula to include value in col Q when no value in col P for that row

[mikeburg]

Need formula in cell P71 to sum Q37:Q40 if a number does not exist in
P3740. For example:

__|___P___|__Q__|
37| 199606 |500.00|
38|_______|650.00|
39| 199808 |850.00|
40|_______|875.00|

Cell P71 should contain 1,525.00 (650.00+875.00).

Thanks for all your help. mikeburg

 

[pinmaster]

Try something like this:

=SUMIF(P3740,"",Q37:Q40)

HTH
JG

 

[Bernard Liengme]

Here are some to try
=SUMIF(P3740,"",Q37:Q40)
=SUMPRODUCT(--(ISBLANK(P3740)),Q37:Q40)
=SUMPRODUCT(--(P3740=0),Q37:Q40)
=SUM(Q37:Q40*(P3740=0)) -----enter this one with SHIFT+CTRL+ENTER rather
than simple ENTER
best wishes

 

[mikeburg]

Thanks a million, guys. I don't know why sometimes I can't think of
something that should be so easy. mikeburg