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

Josh

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" <jhahes.1rg8je_1120151338.6006@excelforum-nospam.com> wrote in
message news:jhahes.1rg8je_1120151338.6006@excelforum-nospam.com...
>
> 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
>

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" <jhahes.1rg8je_1120151338.6006@excelforum-nospam.com> wrote in
message news:jhahes.1rg8je_1120151338.6006@excelforum-nospam.com...
>
> 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
>