Microsoft Office Tutorials and References

In Depth Information

**Chapter 7: Counting and Summing Techniques**

7

Counting and Summing

Techniques

In This Chapter

Information on counting and summing cells

●

Information on counting and summing records in databases and pivot tables

●

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

●

The use of VBA to perform counting and summing tasks

●

Many of the most frequently asked spreadsheet questions involve counting and summing values

and other worksheet elements. It seems that people are always looking for formulas to count or

sum various items in a worksheet. If I’ve done my job, this chapter will answer the vast majority

of such questions.

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 or table.

Table 7-1 lists the worksheet functions that come into play when creating counting and summing

formulas. If none of the functions in Table 7-1 can solve your problem, it’s likely that an array

formula can come to the rescue.