Forum Discussion
Solved
Using a function in COUNTIF criteria
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 th...
If you're looking to obtain a count of all cells with LEN > 8, I'd arrange it like this:
=SUM(N(LEN(A1:A10)>8))The LEN portion of the formula returns TRUE or FALSE, N converts those to 1s and 0s, SUM adds them.
If you're looking to obtain a count of all cells with LEN > 8, I'd arrange it like this:
=SUM(N(LEN(A1:A10)>8))The LEN portion of the formula returns TRUE or FALSE, N converts those to 1s and 0s, SUM adds them.
Thank you a lot, Patrick2788! This workaround works for my specific task and possibly for similar tasks that need to count results of a function applied to each cell in the test range. Good job!
- You're welcome!