Get UNSTUCK with Expert Advice

Press Esc to close

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:

Note

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:

=COUNT(A:A)

previous

next

Home   |   Ask a question   |   Excel Guides   |   Formula Expert Addin   |   FAQs   |   About Us