Sumifs with one fuzzy lookup

[malisesaucier]

I am trying to use sumifs but one criteria with a fuzzy lookup. The data may not be exact for corp data - but some are very similiar in name. (For example: XYZ Corp is same as XYZ Corporation but XYZ BB Corporation is not same as XYZ Corporation.) I have attached sample data that will hopefully explain issue better. It does not seem to be working even with exact data and not sure why at this point.

TIA for any assistance!
Malise

[mikeTRON]

You need to have unique identifiers for the SUMIFs to work correctly.

[liz5818]

what is going where the AAA is? is that your lookup?

[malisesaucier]

The AAA is one part of the criteria. It will have BBB or CCC in other sheets. There will be multiple sheets looking to the one sheet of data.

[FDibbins]

Hi and welcome to the forum

try this, copied down and across...

=SUMIFS(Data!$P$4:$P$20,Data!$D$4:$D$20,LEFT($A11,6)&"*",Data!$Z$4:$Z$20,Summary!B$6)

Note: your heading INVENTORY has a trailing space - remove it
also, the higher you make the ,6) in the LEFT() function, the more accurate the extract will be, but you stand the chance of missing some...your choice

edit: I didnt notice the AAA part, but that should be easy enough to add