Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Statistical > COUNTA

 

COUNTA(value1, value2 [, value3] [,...])

 
 Returns the number of non blank values in a list or cell range.

 value1The first value.
 value2The second value.
 value3(Optional) The third value.

 REMARKS
 
  • This function includes hidden rows.
     
  • This is identical to the COUNT function except that text, logical values and errors are included.
     
  • Arguments that are empty cells are ignored. See Example 7.
     
  • Any arguments that are text or blank strings will evaluate to 1.
     
  • Any arguments that contains True will evaluate to 1.
     
  • Any arguments that contains False will evaluate to 0.
     
  • You can have a maximum of 30 arguments.
     
  • Example 1 -
     
  • Example 2 -
     
  • Example 3 -
     
  • Example 4 -
     
  • Example 5 -
     
  • Example 6 -
     
  • Example 7 -
     
  • Example 8 -
     
  • Example 9 -

     EXAMPLES
     
     ABC
    1=COUNTA(B1) = 1"Text"#DIV/0!
    2=COUNTA(B1:B2) = 214.3#REF!
    3=COUNTA(B1:B5) = 57/1/197720
    4=COUNTA(B1:C5,10,20) = 11""True
    5=COUNTA({1,2,3,4,5}) = 510 
    6=COUNTA(C1:C4) = 4  
    7=COUNTA(C1:C5) = 4  
    8=COUNTA({12,14,14},19,235) = 5  
    9=COUNTA({1,2,3,4,5,"text",TRUE},B1) = 8  
     

     Functions - C | Index - C | Office Online 2013 | 2010 | 2007 | 2003 

     © 2013 Better Solutions Limited. All Rights Reserved.Top | 03-Jan-2013