Excel Count Function

A built-in excel function, Count Function counts the number of cells containing numbers as well as the number of arguments that contain numbers. It is categorized as a statistical function that can be used as a worksheet function.

Syntax

=count (value1, value2,…)

Arguments

• Value1: An Argument/ cell reference/ range
• Value2. Optional. An Argument/ cell reference/ range

Purpose

To count the number of cells containing numbers

Return Type

Numeric

Remarks

• It can handle upto 255 additional values
• For counting logical and text values, use CountA Function and CountIf to count on certain criteria
• Logical values are not counted, but with other statistical functions like ISNUM, MBER, ISTEXT, ISLOGICAL, ISFORMULA, etc., it is possible.
• Empty cells, errors and text are not counted
• Date and time are stored as numbers in Excel, so excel Count Function counts both