SUMIF Using Part of the contents of a cell

Hello Gurus,
I am trying to do sumif using parts of a cell as criterion.
I have searched online and I know about this formula =SUMIF(Range,"*Part*",SumRange), however I noticed this only works when there is a space between the criterion and other contents of the cell. Eg "Part Excuse" but it does not work if we have it like this "Part/Excuse".

What I need

I have this template (see attached and below). This is the raw data.

Product Code Location Quantity
A01 12345/GAR 5
A02 12346/GAR 8
A03 12346/GAR 4
A04 12345/GAR 1
A02 12347/GAR 9
A01 12346/GAR 5
A04 12348/GAR 8
A01 12347/GAR 7
A02 12348/GAR 9
A03 12345/GAR 3
A04 12347/GAR 2
A01 12348/GAR 5
A02 12348/SUL 4
A03 12347/SUL 7
A01 12346/SUL 9
A02 12347/SUL 8
A03 12346/SUL 7
A04 12347/SUL 6
A02 12345/SUL 5
A01 12348/SUL 3
A04 12348/SUL 4
A01 12345/SUL 6
A03 12345/SUL 5
A04 12346/SUL 7

In my raw data, I have products with unique codes (here A01, A02, A03, and A04) with quantites but in different locations with unique codes (12345, 12346, 12347, and 12348). But each location has two or more sub-locations (GAR and SUL), therefore each sub-location is described as Location/Sublocation (12345/GAR, 12345/SUL, 12346/GAR, 12346/SUL, 12347/GAR, 12347/SUL, 12348/GAR and 12348/SUL).

This data is automatically generated, so I cannot change the location code by putting space in between, besides the data is large.
I need a formula that will be able to sum the data based on the product code and location code only (irrespective of the sub-location), that is, the location codes 12347/SUL and 12347/GAR should be generated in the same cell by reading only their common code "12347".

Please find attached to see expected result.

Thanks.

Good Morning.
See if the attachment helps you

Try

=SUMIFS('Raw Data'!$C:$C,'Raw Data'!$A:$A,$A3,'Raw Data'!$B:$B,B$1&"*")

See attached.

Thanks Gfranco, John Topley and Lanceh.

I think Gfranco/John Topley's formula helped better considering the weight of my data, but thanks all the same Lanceh. That is another formula I'd consider exploring.

I appreciate all of you guys.

Hello Gfranco and John Topley,
Sorry for bothering you again on this thread.
In my raw data, there are some data I normally filter out before pasting and this is often tasking and laborious. So I am wondering if there is a way we can add an additional formula to disregard any data whose location ends with "/REC" irrespective of the product or any other thing so that we will still arrive at the same result as the previously solved one. This is just to save me of the time and effort I spend on filtering and manually removing those kinds of data.

As you would see from the attached, the added data (those ending with "/REC" in the rawdata worksheet) has changed the result in H3:K6. However, I want the result to still remain the same way it was in B3:E6.

Thanks.

Thanks so much AliGW. It worked perfectly.

Hi,
Please kindly help with this also. I wish I understood the principles of the conditional SUMIFS using parts of cell contents.

With the same data, I want a formula that adds this time around all the quantities of each product irrespective of their location. The only exception should be the ones that end with /REC.

This is the expected result.

Product Code Total Qty
A01 40
A02 43
A03 26
A04 28

Thanks in advance.

Wow! I just noticed the major difference between SUMIF and SUMIFS. Never really paid attention to that difference prior to this time.
Thanks.