oK.... Why does it work with most of the data, but not all??? How come
sometimes it shows 0 when I can clearly find the data????

"Bob Phillips" wrote:

=SUMPRODUCT(--(Sheet1!A1:A1000=A1),--(Sheet1!B1:B1000=B1,--(Sheet1!C1:C1000=
C1))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dee" wrote in message
...
I would like to do a sumif function. I think SumifS is the function to
use,
but I'm not sure. I would like to sum the quantity shipped one worksheet
if
the MFG #, Manufacturer and Unit Price match on both sheets. Is this
possible with sumifs and if so, how? If not, is there a function that can
do
this?

I appreciate any help you can provide!!! Thank you :o) and have a great
day!!!