Excel COUNTA() Function
Excel COUNTA() Function
The COUNTA() function counts the number of cells in a range that are not empty.
Syntax
COUNTA([value1], [value [2], ...)
Parameter
value1(required)- This parameter represents the first cell in the range.
value2, …(optional)- It represents the second, third and so on cells in the range.
Category
Statistical
Returns
This function returns the count of the number of cells that are not empty.
Example 1
Objective: Use COUNTA function to find the number of cells that are not empty.
List of Numbers | Result | Formula | ||
13 | 11 | 50 | 3 | =COUNTA(A18:C18) |
191 | A | 1 | 3 | =COUNTA(A19:C19) |
82 | 20 | 2 | =COUNTA(A20:C20) | |
-82.5 | B | 2 | =COUNTA(A21:C21) |
Example 2
Rows/Columns | B | C | D | E | F |
90 | Emp_ID | Employee Name | City/State | Department | Salary |
91 | E001 | Beena Singh | New York | Marketing | |
92 | E002 | Ritu Sisodia | Sales Executive | ||
93 | E003 | Gajni Seth | Texas | $115,550 | |
94 | E004 | Ram nath Kovind | Texas | Customer Support | $99,500 |
95 | E005 | Ram nath Kovind | Texas | Customer Support | $35,000 |
Objective: To count the non-empty cells in the data
Result | Formula |
33 | =COUNTA(B90:F95) |