Excel Function: COUNT

The Excel function COUNT is used to determine the number of cells containing numbers.

Usage:

=COUNT(range_of_cells)


Example of use

The goal here is to get the total number of members who made a donation:

excel function count

Select the COUNT function and then simply enter the range of cells in which to count the number of numeric values:

=COUNT(B2:B11)

count function png

Click OK to get the result:

count