For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Statistical function

COUNTA Function

Counts the number of cells that are not empty in a range


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

COUNTA(value1, value2, ...)

  • value1  Required. The first argument with a reference or array you want to count.
  • value2, ...  Optional. Additional arguments with a reference or array you want to count, up to a maximum of 255 arguments.

Applies To

Excel 2003 and above

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples for Excel's COUNTA function

The COUNTA function counts everything that's not a blank, including text, numbers, logical results, and errors.

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards