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 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 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

Other useful "COUNT FUNCTIONS: TEXT BASED CRITERIA" formulas in Excel and Google SheetsOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions