How to Use COUNTA Function in Excel

In this article, we will learn about how to use the COUNTA function in Excel.

COUNTA function is a built in Excel function to calculate the Count of cells having Text, numbers or logic_test.

=COUNTA (value1, [value2], ...)
Non-Empty cells considered by COUNTA function

If we write a formula

=COUNTA(1,2,” Computers”,” ”)

It will return 4 as the count of cell having values are 4.
Here “ ” creates an empty cell but is counted by COUNTA function.
Let’s understand more of this function using it an example.
Here we have some values in column A including the formula in A4 cell.
Use the formula to count cells having any values.


7 is the count of numeric value cells. Fully Empty cells are A6 & A9.
Use the COUNTA function to count text and logic_values in Excel.
Hope you understood how to use COUNTA function in Excel. Explore more articles on built-in Excel cell count function here. Please feel free to state your query or feedback for the above article.

Related Articles:

How to Use COUNT Function in Excel

Count Unique Values In Excel

Checking Whether Cells in a Range are Blank, and Counting the Blank Cells

How to Count Cells In A Range

How to Calculate Only If Cell is Not Blank in Excel

Related Articles:

How to Use COUNT Function in Excel

How to Use COUNTA Function in Excel

The COUNTIFS Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube