Microsoft Office Tutorials and References

In Depth Information

COUNTA

Returns the number of nonblank cells in a range.

COUNTBLANK
Returns the number of blank cells in a range.

COUNTIF

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-

terion.

COUNTIFS*

Counts the number of records in a worksheet database that meet specified

criteria.

DCOUNT

Counts the number of nonblank records in a worksheet database that meet

specified criteria.

DCOUNTA

Returns the sum of squares of deviations of data points from the sample

mean; used primarily in statistical formulas.

DEVSQ

Returns the sum of a column of values in a worksheet database that meet

specified criteria.

DSUM

Calculates how often values occur within a range of values and returns a

vertical array of numbers; used only in a multicell array formula.

FREQUENCY

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.

SUBTOTAL

SUM

Returns the sum of its arguments.

SUMIF

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-

terion.

SUMIFS*

Multiplies corresponding cells in two or more ranges and returns the sum of

those products.

SUMPRODUCT

* 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: