Home/Formulas/Math/SUMIFS
Mathmedium

SUMIFS()

Returns the sum of a range depending on multiple criteria.

Syntax
fx
=SUMIFS(sum_range, criteria_range1, criterion1, ...)
Arguments
ArgumentDescription
sum_rangeThe range to be summed.
criteria_range1The range to check against criterion1.
criterion1The pattern or test to apply to criteria_range1.
Try it
F2
→
90,600
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Argument order is the OPPOSITE of SUMIF: sum_range comes first, then pairs of (criteria_range, criterion).
  • Each criteria_range must be the same shape as sum_range, otherwise you get #VALUE!.
  • Wildcards: "*ab*" matches anything containing "ab". Use ~ to escape literal asterisks.
Related formulas
COUNTIFS()
Returns the count of a range depending on multiple criteria.
Used by
SUM()
Returns the sum of a series of numbers and/or cells.
COUNTIFS()
Returns the count of a range depending on multiple criteria.
More Math formulas →Keyboard shortcuts for Sheets →