COUNTIF (complex) - Google Sheets

[rlong98]

Hello,

I'm puzzled on this one

I have a formula in Conditional Formatting

=NOT(ISERROR(FIND(LOWER(A5),LOWER($B$1))))

This works when I type in a phrase in B1 and it will Highlight all that have some or more of that phrase

GOAL - I want to use that same code in an COUNTIF

=COUNTIF(A5:A30,NOT(ISERROR(FIND(LOWER(A4),LOWER($B$1)))))

I would think that if the first code line works in Conditional Format and highlights the cells, that I could use it in a COUNTIF



I keep getting 0

Thank you!

 

[jasonb75]

could be something in the Language concept?

See post 9, Germany is one of the countries that uses comma instead of dot / period.