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) |