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:
Search JabSto ::




Custom Search