Page 415 - Excel 2013 All-in-One For Dummies

The SUMIFS (that’s ifs, plural) function works like SUMIF function except that it enables you to specify more than one criteria range that controls when a certain range of values are summed. Its syntax is a little bit different:
SUMIFS(sum_range,criteria_range,criteria,)
For this function, the sum_range argument specifies all the possible values that can be summed, the criteria_range specifies the cells with all the entries that are to be evaluated by the if criteria, and the criteria argument contains the expression that is to be applied to the entries in the criteria_range to determine which of the values to total in the sum_range.
Summing certain cells with SUMIF
Figure 5-2 illustrates how you can use the SUMIF function to total sales by the items sold. This figure shows a Sales data list sorted by the store location and then the item sold. In this Daily Sales data list, there are three locations: Mission Street, Anderson Rd., and Curtis Way, of which only sales made at the Anderson Rd. location are visible in this figure.
Math & Trig Functions 397
Figure 5-2:
Using SUMIF to total sales by items sold.
Book III Chapter 5
Math and Statistical Formulas