The counts in column C make it easy to quickly check results.

Note the greater thanoperator(>) is enclosed in double quotes ("") andconcatenatedto F4.

LEN will also count characters in numbers, but number formatting is not included.

Excel formula: Count cells that contain odd numbers

N Function

The Excel N function returns a number when given a value.

The N function can be used to convert TRUE and FALSE to 1 and 0 respectively.

When given a text value, the N function returns zero.

Excel formula: Count cells that contain specific text

Excel formula: Count cells that contain n characters

Excel SUMPRODUCT function

Excel LEN function

Excel N function