Excel Counta Function

Related Functions:
COUNT
COUNTBLANK

Excel COUNT & COUNTA Functions
As the Excel Count and the Excel Counta functions are often confused, the differences are outlined below:
- The COUNT function returns the count of numeric values (i.e. numbers or dates) within a supplied set of cells or values.
- The COUNTA function returns the count of non-blanks within a supplied set of cells or values.

Basic Description

The Excel Counta function returns a count of non-blanks within a supplied set of cells or values.

The function is commonly used to return the number of non-blank cells in a range. However, as well as ranges of cells, the Counta function can directly received arrays of values, which are not stored in cells.

The syntax of the Excel Counta function is :

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

Where the arguments, value1, [value2], etc, can be any values or references to cell ranges.

In Excel 2007 or 2010, you can enter up to 255 value arguments to the Excel Counta function, each of which may consist of any number of cells or values. However, in Excel 2003 and earlier, the function can only handle up to 30 arguments.


Note that, if a cell contains an empty text string or a formula that returns an empty text string, this cell is counted as a non-blank by the Counta function.


Counta Function Examples

Example 1 - Values Supplied from a Range of Worksheet Cells

The following spreadsheet shows two examples of the Excel Counta function used to count non-blank cells in one or more supplied cell ranges.

 Formulas:
  A B C
1 1   =COUNTA( A1:A6 )
2 2 TRUE =COUNTA( A1:A6, B1:B2 )
3 #N/A    
4      
5      
6 text    
 Results:
  A B C
1 1   4
2 2 TRUE 5
3 #N/A    
4      
5      
6 text    

Example 2 - Values Supplied Directly to the Excel Counta Function

The following spreadsheet shows an example of the Excel Counta function, with the values supplied directly to the function.

 Formula:
  A
1 =COUNTA( "text", 1, 2 )
2  
 Result:
  A
1 3
2  

Further examples of the Excel Counta function can be found on the Microsoft Office website.

Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net