COUNT

Excel Functions

Count numbers

Syntax

EXCEL

=COUNT(value1, [value2], ...)

Arguments

Parameter	Description
`value1`	An item, cell reference, or range.
`value2`	[optional] An item, cell reference, or range.

Return Value

Count of numeric values

Details

The COUNT function returns the count of numeric values in the list of supplied arguments. COUNT takes multiple arguments in the form of value1, value2, value3, etc. Arguments can be individual hardcoded values, cell references, or ranges up to a total of 255 arguments. All numbers are counted, including negative numbers, percentages, dates, times, fractions, and formulas that return numbers. COUNT ignores text values, errors, and empty cells. The COUNT function is similar to the COUNTA function, but COUNTA includes numbers and text in the count. The COUNT function counts numeric values and ignores text values: Typically, the COUNT function is used on a range. For example, to count numeric values in the range A1:A10: In the example shown, COUNT is set up to count numbers in the range B5:B15

Examples

The COUNT function counts numeric values and ignores text values:

EXCEL

=COUNT(1,2,3) // returns 3
=COUNT(1,"a","b") // returns 1
=COUNT("apple",100,125,150,"orange") // returns 3

Examples

Typically, the COUNT function is used on a range. For example, to count numeric values in the range A1:A10:

EXCEL

=COUNT(A1:A100) // count numbers in A1:A10

Examples

In the example shown, COUNT is set up to count numbers in the range B5:B15:

EXCEL

=COUNT(B5:B15) // returns 6

COUNT

Syntax

Arguments

Return Value

Details

Examples

See Also