Post your sumproduct formula and a description of what your doing

Mike

"Harsh Bahal" 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.