software

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: www.excelforum.com/member.php...oamp;userid=24581
View this thread: www.excelforum.com/showthread...hreadid=508759
Try something like this:

=SUMIF(P37:P40,quot;quot;,Q37:Q40)

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=508759Here are some to try
=SUMIF(P37:P40,quot;quot;,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

quot;mikeburgquot; gt; wrote in
message ...
gt;
gt; Need formula in cell P71 to sum Q37:Q40 if a number does not exist in
gt; P37:P40. For example:
gt;
gt; __|___P___|__Q__|
gt; 37| 199606 |500.00|
gt; 38|_______|650.00|
gt; 39| 199808 |850.00|
gt; 40|_______|875.00|
gt;
gt; Cell P71 should contain 1,525.00 (650.00 875.00).
gt;
gt; Thanks for all your help. mikeburg
gt;
gt;
gt; --
gt; mikeburg
gt; ------------------------------------------------------------------------
gt; mikeburg's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24581
gt; View this thread: www.excelforum.com/showthread...hreadid=508759
gt;

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: www.excelforum.com/member.php...oamp;userid=24581
View this thread: www.excelforum.com/showthread...hreadid=508759