Counta Function

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.

Syntax: 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

 

Example 3 – Values Supplied Directly to the Excel Counta Function

The following spreadsheet shows an example of the Excel Counta function

Formulas:

Count_Formulas_1

Results:
Count_Result_1

 

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.

 

 

Download Documents

Download Excel File

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment