Table of Contents
About
The Excel COUNT function counts the number of cells that contain numeric values.
Function Type
Statistical
Purpose
Count numbers
Return value
Number equivalent to the count of numbers
Syntax
=COUNT(value1, [value2], …)
Arguments
value1 – The first item, cell reference, or range within which you want to count numbers
value2 – [optional] The second item, cell reference or range.
Examples
=COUNT(A1:A10)Counts how many cells in the range A1 to A10 contain numbers.
Use Case Example: You have test scores in cells A2 through A11. To find out how many students have submitted their scores:
=COUNT(A2:A11)This will give the count of students who have entered numeric scores, excluding blanks or text.
Note:
The COUNT function only includes numeric values and ignores text, logical values, and empty cells.
Video on COUNT Function
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)