# SUMIFS function

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 against `criterion1`.

• `criterion1` - The pattern or test to apply to `criteria_range1`.

• `criteria_range2, criterion2, ...` - [ OPTIONAL ] - Additional ranges and criteria to check.

`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 a1xn + a2x(n+m) + ... + aix(n+(i-1)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 table-like array or range using a SQL-like 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.