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:





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