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

Need formula in cell P71 to sum Q37:Q40 if a number does not exist in
P37:P40. 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


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=508759

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

Try something like this:

=SUMIF(P37:P40,"",Q37:Q40)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=508759

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

Here are some to try
=SUMIF(P37:P40,"",Q37:Q40)
=SUMPRODUCT(--(ISBLANK(P37:P40)),Q37:Q40)
=SUMPRODUCT(--(P37:P40=0),Q37:Q40)
=SUM(Q37:Q40*(P37:P40=0)) -----enter this one with SHIFT+CTRL+ENTER rather
than simple ENTER
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mikeburg" wrote in
message ...

Need formula in cell P71 to sum Q37:Q40 if a number does not exist in
P37:P40. 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


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=508759

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

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


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=508759