Sum If formula for list of names that aren't exact match

[kmsprague]

Hi all,

I have a list of names and amounts that I need to sum, but the names aren't always an exact match. Mainly, the issue is that some names include a middle initial. I know how to use the * to capture cells that contain something, but it's not working with my SUMIF formula (so far).

Name	Amt
Aaron Anderson	$ 5.00
Aaron A. Anderson	$ 5.50

 

[kmsprague]

Hi all,

I have a list of names and amounts that I need to sum, but the names aren't always an exact match. Mainly, the issue is that some names include a middle initial. I know how to use the * to capture cells that contain something, but it's not working with my SUMIF formula (so far).

Name	Amt
Aaron Anderson	$ 5.00
Aaron A. Anderson	$ 5.50

Sorry, I didn't mean to post yet. My current formula is =SUMIFS(B:B,A:A,"*"&D2&"*"). I appreciate any/all ideas and help! Thank you!