Table of Contents
About
SUMIFS function is used to find the sum of cells satisfying a set of specified conditions.
Function Type
Math and trigonometry
Purpose
Get the sum of cells satisfying the specified conditions
Return value
A number equivalent to the sum of cells satisfying the specified conditions
Syntax
=SUMIFS(sum_range,criteria_range1,criteria1,[criteria_range2,criteria2], ...)
Arguments
sum_range – The range of cells containing values to add.
criteria_range1 – The range of cells to evaluate the first condition.
criteria1 – The first condition to check or the first criterion to evaluate.
criteria_range2 – [optional] The range of cells to evaluate the second condition.
criteria2 – [optional] The second condition to check.
Example 1
Example 2
Notes
SUMIFS function supports wildcards.
The height (number of rows) of additional ranges should match with criteria_range1 or else SUMIFS function will return a #VALUE! error.
Non-numeric criterion or condition specified inside SUMIFS needs to be enclosed in double quotes.
To check a single condition, use SUMIF function.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)