To count the total number of cells in a range is simple, but have you ever tried to count the cells by a given length? Not to worry. Here, I am going to introduce a way to count the cells with string length greater than a specific number in Excel. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Formula and Explanation:
- You can use the below formula to count the cells with string length.
=SUMPRODUCT(N(LEN(range)>10))
Function Explanations:
- SUMPRODUCT Function – This function will help to multiply the corresponding arrays or ranges and returns the sum of the products.
- LEN Function – It helps to find the length of a given text string.
- N function – This function will help to convert a value to a number.
Practical Example:
Refer to the below example.
- Here, we will give the input text and length in Column B and Column C.
- Then, apply the above-given formula in the blank cell where want to display the result.
- Press the ENTER key, it will count the cells that are greater than the given criteria.
Wrap-Up:
Hope you understood how to count the cells with string length greater than a specific number in Excel. Let me know your queries in the below comment section. I reply to queries frequently. Continue learning on *Geek Excel!! *
Top comments (0)