SUMIF Discrepencies

Rather than ripping my hair out, I decided to come ask some experts.


--->LINK TO WORKBOOK: https://www.dropbox.com/s/47dcvmm2oq...ults.xlsx?dl=0

I have a base dataset consisting of 15584 lines of online sales data.

I am having to build a Sales by Product report and I am using the SUMIF function to pull the information I need.

The top of my report seems to be functioning correctly using the formula: =SUMIF(Data!B2:B15584, "STL-*",Data!L2:L15584), which should SUM the data in the L2:L15584 range IF the CRITERIA meets "STL-*" found in the B2:B15584 range. (A Text value, and I understand that may be an issue using this function) And yields the expected result.

Slightly further on the page, I have a section labeled SALE BY BRAND/ITEM CATEGORY, most of this section seems to function properly except when I start utilizing this SUM criteria in this equation: =SUMIF(Data!B2:B15584, "STL-AIR-*",Data!L2:L15584) on each category to get the Category Specific Totals.

This issue the SUM of the categories that exists under the STL brand does not equal the DataSet total for the STL Brand as a whole. Something is being left out somewhere or I am having a major issue using TEXT as my criteria in the SUMIF() function.

Should I go about the as a =SUM(IF()) array situation due to my queuing off of a TEXT formatted criteria rather than a number? If so, how would you recommend this?

Thanks for any assistance in advance. The fresh eyes on this is appreciated.

J