writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 3:
Line 3: − + − *Arguments can be numbers, dates or text representation of numbers. − *Logical values, text, error values are ignored. + − + − + − COUNT(A1:A8,7,13) ''returns 6'' as a result. − − − COUNT(1..100) ''returns 100'' as a result. − − COUNT(1..100,5,TRUE,"ONE") ''returns 102'' as a result. Logical value 'TRUE' is not counted. − + + + − − −
no edit summary
*Parameters are any values.
*Parameters are any values.
*COUNT(), counts how many numbers are in the list of arguments.
**COUNT(), counts how many numbers are in the list of arguments.
== Description ==
== Description ==
COUNT()
COUNT()
*Arguments can be numbers, dates or text representation of numbers.
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result.
*Logical values, text, error values are ignored.
*Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result.
*COUNT(A1:A8,7,13) ''returns 6'' as a result.
*COUNT(1..100) ''returns 100'' as a result.
*COUNT(1..100,5,TRUE,"ONE") ''returns 102'' as a result. Logical value 'TRUE' is not counted.
* The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.
* The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.
* Any error values, text, empty cells or logical values are not counted.
* Any error values, text, empty cells or logical values are not counted.
* COUNTA() can be used to count the number of cells with empty text("") or error values.
* COUNTA() can be used to count the number of cells with empty text("") or error values.
* COUNTIF() can be used to count the number of cells that satisfy the given criteria.
* COUNTIF() can be used to count the number of cells that satisfy the given criteria.