Office 2007 Bible

Counting and Summing Worksheet Cells

Generally, a counting formula returns the number of cells in a specified range that meet certain criteria. A summing formula returns the sum of the values of the cells in a range that meet certain criteria. The range you want counted or summed may or may not consist of a worksheet database.

Table 17-1 lists the Excel worksheet functions that come into play when creating counting and summing formulas. Not all these functions are covered in this chapter. If none of the functions in Table 17-1 can solve your problem, it’s likely that an array formula can come to the rescue.

Table 17-1. Excel’s Counting and Summing Functions

Function	Description
COUNT	Returns the number of cells that contain a numeric value.
COUNTA	Returns the number of nonblank cells.
COUNTBLANK	Returns the number of blank cells.
COUNTIF	Returns the number of cells that meet a specified criterion.
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.
DEVSQ	Returns the sum of squares of deviations of data points from the sample mean; used primarily in statistical formulas.
DSUM	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. ...