COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel

The following article introduces you to the COUNTA function - one of the functions in the statistical function group is very popular in Excel.

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 1

Description: The function performs counting nonblank cells in the list of arguments.

Syntax: COUNTA (value1, [value2], .)

Inside:

- value1, value2: List of values, cell ranges or references that want to count, where value1 is a required parameter, the remaining value values are arbitrary and contain up to 255 value values .

Attention:

- The function performs counting cells containing any data type except blank cells.

- In case you do not want to count logical values ​​and text or error values ​​-> use the COUNT function .

- To count values ​​that meet certain conditions -> use the COUNTIF or COUNTIFS functions .

For example:

Counts the number of cells containing the data of the cells in the table below:

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 2

- In the cell to calculate, enter the formula: = COUNTA (D6: D10)

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 3

- Press Enter -> the number of cells containing the data is:

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 4

- In the data table on text values, logic is counted, dates are still counted.

- Where the values ​​are blank cells-> functions are ignored:

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 5

Above are instructions and some specific examples when using the COUNTA function in Excel.

Good luck!