Harsh Bahal;258166 Wrote:
Hi !

I want enter a sumproduct formula involving three ranges. However if
any of
the range does not have a value the formula returns a #div/0! value. I
want
to avoid that. Pl help.

I don't see how a sumproduct function could cause a #div/0! error?
Is there something in your formula where a division is involved?


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72081