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

Statistical

COUNT Function

Counts how many numbers, including date serial numbers, are in the list of arguments


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

Syntax

COUNT(value1,value2,...)

  • value1  Required. An argument that can contain most data types, including references, but only numbers are counted.
  • value2,...  Optional. Up to 254 additional arguments can be included.

Applies To

Excel 2003 and above

Remarks

When COUNT references one cell or a range of cells, it counts only numbers, including date serial numbers. That is, COUNT ignores empty cells, and all text and logical values. Microsoft documentation has never made this clear, because it addresses the last two examples below, which are of no practical value that I can see.

Examples

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

Example of Excel's COUNT function

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards