Sum values based on multiple conditions - Excel - Office.com:
Introduced in Excel 2007, great function for summarizing tables to fuel charts: You want to sum values with more than one condition, such as the sum of sales of a certain product in a certain region. This is when you’d use the SUMIFS function in a formula.