Why won't Sumproduct funciton evaluate this data

  • Thread starter Thread starter cmfuld
  • Start date Start date
C

cmfuld

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))
 
I'd look in the BadDebt range for errors--don't forget to look in hidden
rows/columns.
 
Back
Top