Page 314 - Excel 2007 Bible

19_044039 ch14.qxp 11/21/06 11:06 AM Page 271
Creating Formulas That Count and Sum
Conditional Sums Using Multiple Criteria
The examples in the preceding section all used a single comparison criterion. The examples in this section
involve summing cells based on multiple criteria.
Figure 14.14 shows the sample worksheet again, for your reference. The worksheet also shows the result of
several formulas that demonstrate summing by using multiple criteria.
Using And criteria
Suppose that you want to get a sum of the invoice amounts that are past due and associated with the
Oregon office. In other words, the value in the Amount range will be summed only if both of the following
criteria are met:
n The corresponding value in the Difference range is negative.
n The corresponding text in the Office range is “Oregon.”
FIGURE 14.14
This worksheet demonstrates summing based on multiple criteria.

271 14