Excel 2010 Bible

281

CHAPTER

Creating Formulas

That Count and Sum

IN THIS CHAPTER

Information on counting and

summing cells

Basic counting formulas

Advanced counting formulas

Formulas for performing

common summing tasks

Conditional summing formulas

using a single criterion

Conditional summing formulas

using multiple criteria

M

any of the most common spreadsheet questions involve counting
and summing values and other worksheet elements. It seems that
people are always looking for formulas to count or to sum various
items in a worksheet. If I’ve done my job, this chapter answers the vast
majority of such questions. It contains many examples that you can easily
adapt to your own situation.

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 13.1 lists the Excel worksheet functions that come into play when cre-
ating counting and summing formulas. Not all these functions are covered in
this chapter. If none of the functions in Table 13.1 can solve your problem,
it’s likely that an array formula can come to the rescue.

Cross-Reference
See Chapters 16 and 17 for detailed information and examples of array formu-
las used for counting and summing. n