SUMIFS()
Syntax. SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,...)
Definition. This function adds all numbers in a range matching the search criteria in the criteria ranges.
Arguments
sum_range (required) The cell range in which you want to find the criteria.
criteria_range1 (required) and criteria_range2 (optional) At least one and up to 127 cell ranges in which you want to find the values in criteria1, criteria2, and so on.
criteria1 (required) and criteria2 (optional) The criteria in the form of a number, an expression, or text. The criteria determine which cells will be added. For example, the criteria argument can be expressed as 32, “>32”, “32”, or “apples”.
Background. This function was new in Excel 2007 and finally allows ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.