Chapter 13: Creating Formulas That Count and Sum
307
Using And and Or criteria .......................................................................................
As you may expect, things get a bit tricky when your criteria consists of both And and Or opera-
tions. For example, you may want to sum the values in the Amount range when both of the follow-
ing conditions are met:l (^) The corresponding value in the Difference range is negative.
l The corresponding text in the Office range is Oregon or California.
Notice that the second condition actually consists of two conditions joined with Or. The following
array formula does the trick:
{=SUM((Difference<0)IF((Office=”Oregon”)+
(Office=”California”),1)Amount)}