|
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.
|
|