Tuesday 21 March 2017

Excel - Microsoft Excel COUNTA Function

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. 


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. 

No comments:

Post a Comment