Excel Count Function
Counting is one of the things Excel does best. And if you probe the help files you'll find 5 different counting functions.
But let's turn to the basic COUNT() function.
The COUNT() function receives a range and returns the number of the numeric value found in that range.
For example, if we wanted to calculate the average of the numbers that appear in a certain range (assuming that we didn't use the AVERAGE() function), we could use the following formula:
The COUNT() function can be used to count the numbers in a column even if you don't know the what will be the last cell in the column. This is achieved by passing the entire column as a parameter to the count function in the following way: