sumproduct error

  • Thread starter Thread starter jhahes
  • Start date Start date
J

jhahes

I am trying a sumproduct formula

=SUMPRODUCT((C4:C5000=A4)*(L4:L5000="COOKED")*(H4:H5000))

I GET A DIV/0 ERROR IN THE CELL

Any help would be great.

thank you

Jos
 
You will get that if there is a divide by zero error in any of the cells you
are working with.
 
I think one of the cells H4:H500 has a #DIV/0 error in it.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top