SUMIF WITH WILDCARD CRITERIA

[larper]

I have a file with a column that has multiple business names (which have a ending character that is common for multiple businesses) and I want to sum up the margins (in another column) for business ending the same. So I have business ending in "1" , "B", "D" & "X". So it would be great to like SUMIF(BUSINESS, LIKE %1, MARGIN). I know there is a way, I try a couple of SUMPRODUCT but to no sucess.

Thanks for the Help.

 

[Aladin Akyurek]

=SUMIF(BusinessRange,"*B",MarginRange)

would sum margins corresponding to business names ending in B.