O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

COUNT()

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.

Arguments

  • 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.

Note

All arguments ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required