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) |