I'd look in the BadDebt range for errors--don't forget to look in hidden
rows/columns.

wrote:

I have written a formula that evaluates whether a set of numbers is
"Red", "Yellow" or "Green" based upon whether the numbers meet certain
criteria. I would then like to count the number of "Red" instances.
I have named the range of data(Red,Yellow, Green). I can't figure out
why the following function returns a #DIV/0!

SUMPRODUCT(--(BadDebt=$E$8))

--

Dave Peterson