New answers tagged

0

Use REGEXMATCH : =countif(ArrayFormula(regexmatch(A1:A10,"^Bud Light$")),true) This formula counts the cells who match the regex ^Bud Light$ : Match exactly Bud Light You can add lower() and proper()to clean the range you want to test.


Top 50 recent answers are included