Google Sheets Function: COUNTA

The COUNTA function returns the number of non-empty cells within a specified range of cells.



Usage Example

The COUNTA function here will return the number of members who made a donation by counting the number of non-empty cells:

google sheets counta function

Enter the cell range B2 to B11 into the COUNTA function to count the number of values:

google sheets counta function non empty