Syntax:
SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2)
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:

