Counts the number of arguments that contain numbers.
Syntax
COUNT(value1,value2,...)
Value1, value2, ... are 1 to 30 arguments that can contain or refer to a variety of different types of data, but only numbers are counted.
Remarks
-
Arguments that are numbers, dates, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored.
-
If you need to count logical values, text, or error values, use the COUNTA function.
Examples
|
Col1 |
Col2 |
Col3 |
Col4 |
Col5 |
Col6 |
Col7 |
Formula |
Description (Result) |
|---|---|---|---|---|---|---|---|---|
|
Sales |
12/8/2008 |
19 |
22.24 |
TRUE |
#DIV/0! |
=COUNT([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7]) |
Counts the number of arguments that contain numbers in the list (3) |
|
|
19 |
22.24 |
TRUE |
#DIV/0! |
=COUNT([Col4],[Col5],[Col6],[Col7]) |
Counts the number of arguments that contain numbers in the last 4 rows of the list (2) |
|||
|
Sales |
2/8/2008 |
19 |
22.24 |
TRUE |
#DIV/0! |
COUNT([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7],2) |
Counts the number of arguments that contain numbers in the list, and the value 2 (4) |
