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

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=38360