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

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

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

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

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

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