SUMIFS
Returns the sum of a range depending on multiple criteria.
Sample Usage
SUMIFS(A1:A10, B1:B10, ">20")
SUMIFS(A1:A10, B1:B10, ">20", C1:C10, "<30")
SUMIFS(C1:C100, E1:E100, "Yes")
Syntax
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

sum_range
 The range to be summed. 
criteria_range1
 The range to check againstcriterion1
. 
criterion1
 The pattern or test to apply tocriteria_range1
. 
criteria_range2, criterion2, ...
 [ OPTIONAL ]  Additional ranges and criteria to check.
See Also
SUM
: Returns the sum of a series of numbers and/or cells.
SUMIF
: Returns a conditional sum across a range.
SUMSQ
: Returns the sum of the squares of a series of numbers and/or cells.
SERIESSUM
: Given parameters x
, n
, m
, and a
, returns the power series sum a_{1}x^{n} + a_{2}x^{(n+m)} + ... + a_{i}x^{(n+(i1)m)}, where i is the number of entries in range `a`.
QUOTIENT
: Returns one number divided by another, without the remainder.
PRODUCT
: Returns the result of multiplying a series of numbers together.
MULTIPLY
: Returns the product of two numbers. Equivalent to the `*` operator.
MINUS
: Returns the difference of two numbers. Equivalent to the `` operator.
DSUM
: Returns the sum of values selected from a database tablelike array or range using a SQLlike query.
DIVIDE
: Returns one number divided by another. Equivalent to the `/` operator.
COUNTIF
: Returns a conditional count across a range.
ADD
: Returns the sum of two numbers. Equivalent to the `+` operator.
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.