Count cells that contain n characters
In this example, the goal is to count the number of cells in B5:B15 that contain a given number of characters, where the number of characters n is provided as a variable in cell E4.
SUMPRODUCT with LEN
One way to solve this problem is to use the ...Read more