SUMIFS

Adds cells that meet multiple conditions across several ranges.

Syntax

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Arguments

sum_range - The cells to add. Note this comes first, unlike SUMIF.
criteria_range1 - The first range to test.
criteria1 - The first condition.

Examples

=SUMIFS(C2:C50, A2:A50, "West", B2:B50, ">100")

Returns: Sum of C where A is West AND B > 100

Every criteria pair must be true for a row to be included.

Common Errors and Gotchas

sum_range is the FIRST argument in SUMIFS but the LAST in SUMIF - a very common mix-up.
All ranges must be the same size.

Does SUMIFS Work in Google Sheets?

Yes. SUMIFS uses the same syntax in Google Sheets and LibreOffice Calc, so you can paste these formulas straight across.

See Also