How to count cells with length greater than a specific number in Excel?
To count the total number of cells in a range is simple, but how about counting cells by a given length? In this article, I am going to introduce a way about counting cells with length greater than a specific number in Excel.
Count cells with length greater than a specific number
There is a formula that can help you quickly count the cells with a length greater than a number.
Select a blank cell which you will place the counting result at, type this formula, =SUMPRODUCT(N(LEN(A1:A4)>230)), press Enter key, the result has been shown.
In the formula, A1:A4 is the cell range you will count, 230 is the given length you want to count by.
Tip. if you want to count the number of a specific character such as “s” in each cell, you can apply Kutools for Excel’s COUNTCHAR function, just need to type this formula =COUNTCHAR(A26,"s"), then drag fill handle over cells. It’s full function without limitation in 60 days, please download and have a free trial now.