The COUNTA function is used to count the number of non-empty cells within a specified range. It is frequently used in Excel to determine the total count of cells containing any type of data or value, including text, numbers, errors, and logical values.


=COUNTA(value1, [value2, ...])

value1 value2 ... One or more arguments representing the range cell references or individual values to be evaluated for counting. These can be references to cells ranges or actual values separated by commas.


When you need a simple yet powerful method to tally non-empty cells and comprehensively assess the filled content within specified cells or ranges, the COUNTA function in Excel takes center stage. It excels in swiftly summarizing the presence of any type of value, spanning from text and numerical entries to logical values and errors, offering an encompassing overview of data completeness in your workbook's cells. Utilize COUNTA to fuel your data analysis and decision-making, whether it's scrutinizing the completeness of a dataset or monitoring the input status of a designated range of cells, COUNTA proves to be a reliable ally in your Excel endeavors.


To count the number of non-empty cells in the range A1:A10, use the formula: =COUNTA(A1:A10)

To count the total non-empty cells across multiple ranges, you can combine the ranges as arguments: =COUNTA(A1:A10, B1:B10, C1:C10)


What types of data does the COUNTA function count?

The COUNTA function counts any non-empty cell containing text, numbers, errors, or logical values within the specified range or as individual arguments.

Does the COUNTA function count blank or empty cells?

No, the COUNTA function specifically focuses on counting non-empty cells, and thus does not include blank or empty cells in its count.

Can I use the COUNTA function across multiple ranges or individual cells?

Yes, you can use the COUNTA function with multiple ranges or individual cells as arguments to simultaneously count the non-empty cells across the specified ranges or values.

Related functions