Search code examples
excelwindowsformulacase-sensitivesumifs

Excel Sumifs is casesensitiv on a different computer

we're working with an excel sheet where we use SUMIFS. We've a column for the criteria with values like "High" or "Low". Our SUMIFS function looks for "HIGH" in that column and since the function isn't case sensitive it works well. However a collogue in turkey has the issue that the function doesn't work because the function seems to be case sensitive on his computer. Is this caused by the different language settings on his Windows/Excel installation? Or is there a setting in excel where you can switch the function to case sensitive?

Thanks!

Solution

  • Indeed, Turkish is one of those languages where the length of a string is sensitive to a case conversion.

    So quite often you will find case sensitivity set to true in such a language.

    You can force the issue yourself by using the function UPPER() or LOWER() in an Excel formula, making a case conversion at the point of use.