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.

"Dee" wrote:

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