Syntax. COUNT(value1,value2,...)

Definition. This function calculates how many numbers are included in an argument list. The COUNT() function calculates the number of entries in a number field that is in a range or array of numbers.


  • value1 (required) and value2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions). The arguments can contain or refer to different types of data, but only numbers are counted.

Background. The COUNT() function performs a simple task but can save a lot of time. Especially for tables containing a large number of values, the task of manual counting would be very time consuming. If you need to count the values in a table, this function does the work for you.


All arguments ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.