SUMIFS in Excel 2007
Sumifs adds the cells in a range based on multiple criteria. It is important to note that the sum_range argument is the first argument in SUMIFS, but it is the third argument in SUMIF.
Sum_range is one or more cells to sum, including numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.
Criteria_range1, criteria_range2, … are 1 to 127 ranges in which to evaluate the associated criteria. In SUMIFS each criteria_range must be the same size and shape as sum_range.
Criteria1, criteria2, … are 1 to 127 criteria in the form of a number, expression, cell reference, or text that define which cells will be added. For example, criteria can be expressed as 100, “200”, “>54”, “Harry”, or C2. You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
Example: Adding amounts from four bank accounts based on percentage of interest paid. Only those amounts will be added when they meet all the defined criteria as shown in the Excel training video below:
Excel SUMIFS Function