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

Home > Software design > How to combine Countif & UPPER functions in google sheet to count all matches?

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

Time：12-21

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?

CodePudding user response：

use just:

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