Is it possible to use a function inside COUNTIF criteria so that it is applied to each cell in the range under test? For instance, I have column A of text values and want to count cells in it with the text longer than 8. I’m trying to write something like =COUNTIF(A:A,LEN(A1)&”>8″), but it doesn’t work. What is a correct syntax if possible?

​Is it possible to use a function inside COUNTIF criteria so that it is applied to each cell in the range under test? For instance, I have column A of text values and want to count cells in it with the text longer than 8. I’m trying to write something like =COUNTIF(A:A,LEN(A1)&”>8″), but it doesn’t work. What is a correct syntax if possible?  Read More

​