How to use the COUNT Function in Excel:
The COUNT function counts the number of cells in a range that contain numbers.
In the above image, we have placed numbers, letters and blank spaces in column A & B from rows 1-9
Column D9 displays the COUNT function which comes up to a count of 9.
As you can see, we are looking at a total of 18 cells, but there are only 9 number values within the 18 cells. The COUNT function will not count the cells that contain letters and blanks.
Cell D9 Formula: =COUNT(A1:A9,B1:B9)