COUNT Function

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)