COUNT
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.
Example
| 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) |