# Count cells over 10 characters in Excel and Google Sheets

{=SUM(N(LEN(A:A)>10))} // array formula

=SUMPRODUCT(N(LEN(A:A)>10)) // count within a column

=SUMPRODUCT(N(LEN(A:A)>10)) // count within a cell

### A:A = Range

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

# Count cells over 10 characters in Excel

How to count cells over 10 characters in Excel?

# COUNT CELLS OVER 10 CHARACTERS — EXCEL FORMULA AND EXAMPLE

=SUMPRODUCT(N(LEN(A:A)>10)) // count within a column

=SUMPRODUCT(N(LEN(A3)>10)) // count within a cell

{=SUM(N(LEN(A:A)>10))}

💡 3rd formula will produce the same result as the above two

# Count cells over 10 characters in Google Sheets

How to count cells over 10 characters in Google Sheets?

# COUNT CELLS OVER 10 CHARACTERS — GOOGLE SHEETS FORMULA AND EXAMPLE

=SUMPRODUCT(N(LEN(A:A)>10)) // count within a column

=SUMPRODUCT(N(LEN(A3)>10)) // count within a cell

=ArrayFormula(SUM(N(LEN(A:A)>10)))

💡 3rd formula will produce the same result as above two