Changes

280 bytes added ,  20:57, 1 November 2013
no edit summary
Line 4: Line 4:  
*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>
writer
2,661

edits