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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
