Search code examples
arraysgoogle-sheetsgoogle-sheets-formulacountingcountif

How to combine Countif & UPPER functions in google sheet to count all matches?

I'm trying to find all matches regardless of capital or small letters by using this formula =countif(AllCases!A1:A100,UPPER"*ICU*")

but it didn't work. Any idea?

Solution

  • use just:

    =COUNTIF(AllCases!A1:A100; "*ICU*")