Excel 2010 Bible

Part II: Working with Formulas and Functions

306

FIGURE 13.15

This worksheet demonstrates summing based on multiple criteria.

Using Or criteria .....................................................................................................

Suppose that you want to get a sum of past-due invoice amounts or ones associated with the

Oregon office. In other words, the value in the Amount range will be summed if either of the fol-

lowing criteria is met:

l The corresponding value in the Difference range is negative.

l (^) The corresponding text in the Office range is Oregon.
This example requires an array formula:
{=SUM(IF((Office=”Oregon”)+(Difference<0),1,0)*Amount)}
A plus sign (+) joins the conditions; you can include more than two conditions.