Page 293 - Excel 2007 Bible

19_044039 ch14.qxp 11/21/06 11:06 AM Page 250
Part II
TABLE 14.1
Excel’s Counting and Summing Functions
Description
Function
Returns the number of cells that contain a numeric value
COUNT
COUNTA
Returns the number of nonblank cells
COUNTBLANK
Returns the number of blank cells
Returns the number of cells that meet a specified criterion
COUNTIF
COUNTIFS*
Returns the number of cells that meet multiple criteria
DCOUNT
Counts the number of records that meet specified criteria; used with a worksheet database.
DCOUNTA
Counts the number of nonblank records that meet specified criteria; used with a worksheet
database.
Returns the sum of squares of deviations of data points from the sample mean; used primarily
DEVSQ
in statistical formulas
DSUM Working with Formulas and Functions
Returns the sum of a column of values that meet specified criteria; used with a worksheet
database.
FREQUENCY Calculates how often values occur within a range of values and returns a vertical array of
numbers. Used only in a multicell array formula,
SUBTOTAL When used with a first argument of 2, 3, 102, or 103, returns a count of cells that comprise a
subtotal; when used with a first argument of 9 or 109, returns the sum of cells that comprise
a subtotal
SUM Returns the sum of its arguments
SUMIF Returns the sum of cells that meet a specified criterion
SUMIFS* Returns the sum of cells that meet multiple criteria
SUMPRODUCT Multiplies corresponding cells in two or more ranges and returns the sum of those products
SUMSQ Returns the sum of the squares of its arguments; used primarily in statistical formulas
SUMX2PY2 Returns the sum of the sum of squares of corresponding values in two ranges; used primarily in
statistical formulas
SUMXMY2 Returns the sum of squares of the differences of corresponding values in two ranges; used
primarily in statistical formulas
SUMX2MY2 Returns the sum of the differences of squares of corresponding values in two ranges; used
primarily in statistical formulas
* These are new functions, available only in Excel 2007.
250