Excel Function: COUNTA

The Excel function COUNTA is used to determine the number of cells that are not empty.

Usage:

=COUNTA(range_of_cells)


Example of use

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

excel function counta

Select the COUNTA function and then simply enter the range of cells in which to count the number of non-empty cells:

=COUNTA(B2:B11)

counta function png

Click OK to get the result:

counta