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)  



ADVERTISEMENT
ADVERTISEMENT