The powerful Excel COUNTA Function stands for the count all. The function counts not only empty text, “ ”, text and numbers but also logical/error values. Look at the easy to follow COUNTA examples.
Formula
=COUNTA(my_Arg1,[my_Arg2],...)
Example 1
How to count cells with text using Excel COUNTA Function in a range of cells.
- Click C9
- Type =COUNTA(C4:C8)
- Press enter
NOTE: Cell C6 is blank
Figure 1. Example 1 of Excel COUNTA Function counting non-blank cell
Example 2
- Select D9
- Enter
=COUNTA(D4:D8,"ipad","Android Tablets")
In the example below a user can combine the range and value arguments within the Excel COUNTA Function.
Figure 2. Example 2 combines range and values in the arguments
Explanation
The Excel COUNTA Function counts non-blank cells in a range. The Excel COUNTA Function returns a numeric value representing non-blank cells. It is a worksheet function in the statistical category. Besides, it is inbuilt into Excel. In the three examples, we explore the use of Excel COUNTA Function.
Let’s look at example 2 of the COUNTA function. When we modify the first function to include the range (D4:D8) having 3 values (99,88,14) it then adds two more values “ipad” and “Android Tablets” and the error value (#DIV!) to make a total of 6.
Tips
- When COUNTA detects a blank cell it will return (0)
- Use no more than 255 arguments in the Excel COUNTA Function
Leave a Comment