Chapter 13: Using Formulas for Conditional Analysis
13
FIGURE 13.11
A partial listing of countries and their gross domestic product
In this example, each cell in D3:D212 is added to the total only if the corresponding values
in B3:B212 and C3:C212 meet their respective conditions. The condition for B3:B212 is that
it matches whatever is in cell G3. There are two year conditions because we need to define
the lower bound and upper bound of our year range. The lower bound is in cell G4, and the
upper bound is in cell G5. Those two cells are concatenated with greater than or equal to
and less than or equal to, respectively, to create the year conditions. Only if all three condi-
tions are true is the value included in the total.
Summing if values fall between a given date range
One way that you can use SUMIF with two or more conditions is to add or subtract multiple
SUMIF calculations. If the two conditions operate on the same range, this is an effective