Microsoft Office Tutorials and References
In Depth Information
Returns the number of nonblank cells in a range.
COUNTBLANK Returns the number of blank cells in a range.
Returns the number of cells in a range that meet a single specified criterion.
Returns the number of cells in a range that meet one or more specified cri-
Counts the number of records in a worksheet database that meet specified
Counts the number of nonblank records in a worksheet database that meet
Returns the sum of squares of deviations of data points from the sample
mean; used primarily in statistical formulas.
Returns the sum of a column of values in a worksheet database that meet
Calculates how often values occur within a range of values and returns a
vertical array of numbers; used only in a multicell array formula.
When used with a first argument of 2 or 3, returns a count of cells that make
up a subtotal; when used with a first argument of 9, returns the sum of cells
that make up a subtotal. Ignores other nested SUBTOTAL functions.
Returns the sum of its arguments.
Returns the sum of cells in a range that meet a specified criterion.
Returns the sum of the cells in a range that meet one or more specified cri-
Multiplies corresponding cells in two or more ranges and returns the sum of
* These functions were introduced in Excel 2007.
Other Counting Methods
As is often the case, Excel provides more than one way to accomplish a task. This chapter deals with standard
formulas to count and sum cells.
Other parts of this book cover additional methods that are used for counting and summing: