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


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



  • 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


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.


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