Search
Clear search
Close search
Google apps
Main menu

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

  • criterion1 - The pattern or test to apply to criteria_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 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.

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?