SumIf with Multiple Criteria

[Dee]

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 ) and have a great day!!!

 

[Bob Phillips]

=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)

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 ) and have a great

day!!!

 

[Dee]

I didn't see your post, but i read through all the other posts dealing with
this and it took me a bit, but I finally figured it out!!! THANKS!!!

 

[Dee]

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????

 

[Dee]

Nevermind.... lol I figured it out. Hate to say it, but there were some
numbers stored as text and it wouldn't match the other criteria because the
other criteria was stored as a number. DUH. Thanks anyway.