Math and Trignometric - SUMIFS Function

Description

The SUMIFS Function adds all of its arguments that meet multiple criteria.

SUMIFS (sum_range, criteria_range1, criteria1, [criteria_range2, criteria2] ...)

Argument	Description	Required/Optional
Sum_range	The range of cells to sum.	Required
Criteria_range1	The range that is tested using Criteria1. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.	Required
Criteria1	The criteria that defines which cells in Criteria_range1 will be added.	Required
Criteria_range2, criteria2, …	Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.	Optional

If the length of any of the supplied criteria_range arrays is not equal to the length of the sum_range array, SUMIFS returns #VALUE! Error.
You can use wildcard characters like the question mark (?) and asterisk (*) in criteria1, 2 to find matches that are similar but not exact.
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 (~) in front of the question mark.
The order of arguments differ between SUMIFS and SUMIF. In particular, the sum_range argument is the first argument in SUMIFS, but it is the third argument in SUMIF.
The Criteria_range argument must contain the same number of rows and columns as the Sum_range argument.

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_math_trigonometric_functions.htm