Microsoft Office Tutorials and References
In Depth Information
Chapter 17: Creating Formulas That Count and Sum
TABLE 17.1 Excel Counting and Summing Functions
Returns the number of cells that contain a numeric value.
Returns the number of nonblank cells.
Returns the number of blank cells.
Returns the number of cells that meet a speciﬁ ed criterion.
Returns the number of cells that meet multiple criteria.
Counts the number of records that meet speciﬁ ed criteria; used with a
Counts the number of nonblank records that meet speciﬁ ed criteria; used
with a worksheet database.
Returns the sum of a column of values that meet speciﬁ ed criteria; used with
a worksheet database.
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 ﬁ rst argument of 2 , 3 , 102 , or 103 , returns a count of cells
that comprise a subtotal; when used with a ﬁ rst argument of 9 or 109 ,
returns the sum of cells that comprise a subtotal.
Returns the sum of its arguments.
Returns the sum of cells that meet a speciﬁ ed criterion.
Returns the sum of cells that meet multiple criteria.
Multiplies corresponding cells in two or more ranges and returns the sum of
* These functions were introduced in Excel 2007.
Getting a Quick Count or Sum
The Excel status bar can display useful information about the currently selected cells — no formulas
required. Normally, the status bar displays the sum and count of the values in the selected range. You
can, however, right-click the status bar to bring up a menu with other options. You can choose any or
all of the following: Average, Count, Numerical Count, Minimum, Maximum, and Sum.