# Excel COUNT() Function

Excel COUNT() Function

The COUNT() function counts the number of cells in a range that contain numbers.

Syntax

`COUNT([value1], [value , ...)`

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, which consist of numbers.

Example 1

Objective: Use the COUNT function to find the number of numeric values

 List of Numbers Result Formula 13 11 50 3 =COUNT(A1:C1) 191 A 1 2 =COUNT(A2:C2) 82 20 2 =COUNT(A3:C3) -82.5 B 1 =COUNT(A4:C4)

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 get the count of numerical values in the above data

 Result Formula 13 =COUNT(B90:F95)