Using Sumifs formula to match upper and lower case names

[jb00976]

Hello, I have the following formula:

=SUMIFS('Splits-YTD'!D8:D1050,'Splits-YTD'!F8:F1050,A8)

the name under A12 is as follows Bob Smith. Under the tab Splits-YTD the name can show up in column F as follows: Bob SMITH or BOB SMITH or Bob Smith. My current formula doesn't seem to be catching all the variations how can I fix this? I don't want to change the information in the tab Splits-YTD as I paste that information in monthly, I want my formula to be able to recognize all variations.

Thanks in advance for any assitance

 

[Joe4]

Welcome to the Board!

The SUMIFS formula is not context sensitive, and should count all variations in which the only difference is case.
If you are not finding that to be the case, I think you have something else going on, like extra spaces in the entries.

Find some rows that do not seem to be included in the count. Let's say that it is cell F12. What does this formula return?

=LEN(F12)

If it is not returning 9, then you have some extra spaces in there that is messing up your SUMs!

 

[jb00976]

Thanks I will check the spacing issues.