sumifs returning 0's

Hello,

What I am trying to do is populate the sales volume for each sku in yellow on sheet page 1. The data is being pulled from sheet 1. So, if you look at column C on page 1 sheet, it has the sku Direx 4L. What they are meaning to say is to consider all skus Direx 4L. So, in this case there are two skus of direx 4L (Sheet 1 column L... I have already removed all dups and these are the independent values). What I want to do is to add all of the ship quantity's for both Direx 4L skus and be able to match item to the branch that shipped them. See my formula on page 1 C:8, if your not catching what im throwing here. The formula may speak more. I hope someone can help. Thank you all in advance.

If you're trying to make that an OR...
If Sheet1!D:D = Sheet1!L14 OR L15, then try

=SUMPRODUCT(SUMIFS(Sheet1!G:G,Sheet1!D:D,Sheet1!L14:L15,Sheet1!F:F,'Page 1'!B8))

Confused!

Are you trying to match description or invoice number?

Typically, when SKU's are mentioned, I would expect to match a unique identifier, (product code, bar code, etc.) but Page 1 has no such identifiers.

Shot in the dark

=SUMIFS(Sheet1!G:G,Sheet1!D:D,TRIM(C$4)&"*",Sheet1!F:F,$B8)

Whatever it is, I'm sure it could be done better with a pivot table.

What I want to do is see that in column C on Page 1 I have the product Direx 4L. Fine... Well the vendor didn't specify what package size, and I just happen to know that we have two sku's of Direx 4L, which I have removed dups on in column L of Sheet 1. So.. I then want to somehow add the shipped quantities for both direx 4 L sku's (L14 &15 from Sheet 1) that apply to location 01 for Greenville. So ultimately, I want to know what the total shipped qty's were for both sku's of Direx 4L for location Gville (01), if this makes sense?

Jason,

Your formula worked. Thank you so much! Couple of questions for you if you do not mind:

1. Trim (C$4). Why did you do this and why is row 4 fixed?

2. & "*" --> what does this mean or what is this telling excel to do?

Trim is used to remove the spaces in front of the item description in C4, without removing them, C4 would not match the list on Sheet1.

&"*" is a wildcard, so C4&"*" looks for anything that begins with whatever is in C4.

Row 4 is fixed so you can copy the formula down to C26 without needing to edit each time.

Fixing the columns as well will allow you to copy the formula to F7, I7, L7 etc. without editing (enter it into C7, then copy C7 and paste where needed).

=SUMIFS(Sheet1!$G:$G,Sheet1!$D:$D,TRIM(C$4)&"*",Sheet1!$F:$F,$B8)

Still a lot of pasting, but quicker than editing.

Jason,

Thanks again so very much. I'm looking at column I for Captan 4L and I'm getting 0's down, but I know there is data for this sku. Do you know what may be going on?

Nevermind. I didnt bring in the sku. Your formula is perfect. Sorry.

Haha, an easy mistake to make.

Have a look at this as an alternative that doesn't take so long to set up.