SUMIFS Function in Google Sheets

Syntax

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Description

Returns the sum of a range depending on multiple criteria.

Tips & Best Practices

Note: sum_range comes FIRST, unlike SUMIF. Supports up to 127 criteria pairs.

Example

=SUMIFS(...)

The SUMIFS function belongs to the Math category of Google Sheets functions.

Related Functions

• SUM — Returns the sum of a series of numbers and/or cells....
• SUMIF — Returns a conditional sum across a range....
• SUMPRODUCT — Multiplies corresponding components in arrays and returns the sum....
• AVERAGE — Returns the numerical average value in a dataset, ignoring text....
• AVERAGEIF — Returns the average of a range depending on criteria....
• AVERAGEIFS — Returns the average of a range depending on multiple criteria....

Need Help with SUMIFS?

If you're struggling with SUMIFS or need a custom formula built for your business, our Google Sheets experts can help. Get a free quote →