Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > COUNT
 

COUNT(value1 [,value2] [,...])

 
 Returns the number of numeric values in a list or array of numbers.

 value1The first value.
 value2The second optional value.

 REMARKS
 
  		• Arguments that are numbers, dates, or text representations of numbers are counted.
     
  		• Arguments that are text, logical values or errors are ignored.
     
  		• Arguments that are empty cells are ignored. See Example 5.
     
  		• If an argument is an array or reference, only numbers in that array or reference are counted. See Example 11.
     
  		• Use this function to get the number of entries in a number field in a range (or array) of numbers.
     
  		• Dates and formulas that evaluate to numbers will be included.
     
  		• You can have a maximum of 29 arguments.
     
  		• If you do not want to count any arguments that are text, logical values or errors you can use the COUNTA() function.
     
  		• COUNTFORMAT() - Returns the number of cells that have a particular format.

     EXAMPLES
     
     ABC
    1=COUNT(B1) = 0"Text"#DIV/0!
    2=COUNT(B2) = 114.3#REF!
    3=COUNT(B1:B3) = 27/1/197720
    4=COUNT(B1:B5) = 3""True
    5=COUNT(B1:C5) = 410 
    6=COUNT(B5,2) = 2  
    7=COUNT(10,5,TRUE) = 3  
    8=COUNT(10,5,FALSE) = 3  
    9=COUNT(10,5,FALSE,"some text") = 3  
    10=COUNT({1,2,3,4,5}) = 5  
    11=COUNT({1,2,3,4,5,"some text",TRUE}) = 5  
    		 
     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top