sumproduct error
 

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

sumproduct error
 

You will get that if there is a divide by zero error in any of the cells you
are working with.

--
Regards,
Tom Ogilvy


"jhahes" wrote in
message ...

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

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=383608

sumproduct error
 

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)


"jhahes" wrote in
message ...

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

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=383608