Excel > Functions

COUNTA Function

The COUNTA function counts the number of non empty cells in a given range. COUNTA will count cells containing values, labels and formulas.

The syntax for the COUNTA function is:

=COUNTA(value1,value2,...)

Argument

Purpose

Value1,value2,...

the range of cells you want to count. The function can take up to 30 different cell ranges

The example below demonstrates the COUNTA function being used to count a range of cells.

COUNTA function counting a range of cells

Follow us on

Facebook  Twitter  You Tube 

Other Statistical Functions

Excel 2010 Superhero Course