writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 4:
Line 4: − + − + + + + + + + +
no edit summary
*COUNT() returns the number of cells that contain numbers within the list of arguments.
*COUNT() returns the number of cells that contain numbers within the list of arguments.
*Arguments can be numbers, dates or text representations numbers that are counted.
*Arguments can be numbers, dates or text representation of numbers.
*Logical values and text representations of numbers are ignored.
*Logical values, text, error values are ignored.
== Description ==
== Description ==
COUNT(V1,V2...)
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 5'' as a result.
* 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.
<!--
<!--
</div>
</div>