Part II: Working with Formulas and Functions
FIGURE 13.8
Summing values less than zero
The SUMIF function has an optional third argument called the sum_range. So far, we’ve
been applying the condition to the very numbers we are summing. By using the third argu-
ment, we can sum a range of numbers but apply our conditions to a different range. Figure
13.9 shows a listing of regions and their associated sales. To sum the sales for the East
region, use the formula =SUMIF(B2:B11,"East",C2:C11).
FIGURE 13.9
List of regions and sales values
