Excel Function: COUNTA

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



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 function png

Click OK to get the result: