I. Intro
The COUNTA function returns the number of cells that are not blank in a data set.
II. About the function
- Formula: =COUNTA(value1,[value2,...])
- Parameters:
- value1 (required): The first value to count.
- value2 (optional): Additional values to count.
- Example: =COUNTA(A2:A100,B2:B100)
III. Steps
Use the COUNTA function
- Select a cell and click Formulas on the toolbar, then select Statistical > COUNTA. You can also directly enter =COUNTA in a cell.
- Enter the parameters in the cell. For example: =COUNTA(A2:A5,A8:A11).
- Press Enter to get the result, which is 8 in this example.
250px|700px|reset
Delete the COUNTA function
Select the cell with the COUNTA function and press Delete.