Error values propagate through formulas. Likely there is a #DIV/0!
error in one of the named ranges. If appropriate, you could wrap the
ranges in an IF to strip out errors as in
IF(ISERROR(range),"",range)
Jerry
Irrational wrote:
> Hi
>
> I'm building a recruitment register and I've come up with a DIV/O!
> error in a sumproduct formula where there is no division in the formula
> - I have several sumproduct formulas and named ranges (all named ranges
> are the same length) that work, except for this particular formula.
>
> Basically the formula is (where Position etc are named ranges):
> =sumproduct(((Position=a1)*(Evaluation_Grade=a2)*(Source_Ref="Not on
> List")))
>
> (A1 is text, A2 is a numeric value)
> All my other sumproduct formulas are working that use the Position and
> Evaluation_Grade Named Range.
>
> The Source_Ref range was previously working on an older version. As
> mentioned all Named ranges are the same length and the text in the
> formula has been copied from the data sample to ensure accuracy.
>
> I've tried auditing and evaluating the error and nothing explains the
> DIV/0! error.
>
> Any solutions would be mucly appreciated.
>
> M.
Bookmarks