fx =SUMIFS(C1:C100,A1:A100,"East",B1:B100,">1000")ABCQ1 Sales$42,500$170,000Q2 Sales$38,200Q3 Sales$51,800
📊 Math

SUMIFS Formula for Math

Sum values meeting multiple conditions. Copy-paste ready for Excel, Google Sheets, and Airtable.

=SUMIFS(C1:C100,A1:A100,"East",B1:B100,">1000")
When you need this: When you need to total sales only from the East region (column A) where individual sales exceed $1,000 (column B).

How it works

  1. 1Specify the sum range (C1:C100) containing amounts to total.
  2. 2Add the first criteria range (A1:A100) and its criterion ("East").
  3. 3Add the second criteria range (B1:B100) and its criterion (">1000").
  4. 4Sum only rows matching ALL conditions.

Variations

Sum with 3 conditions
=SUMIFS(D1:D100,A1:A100,"East",B1:B100,">1000",C1:C100,"Active")
SUMIFS with date criteria
=SUMIFS(B1:B100,A1:A100,">=2024-01-01",A1:A100,"<=2024-12-31")

Related Formulas

SUM — Add up a range of numbersMathSUMIF — Sum values that meet a single conditionMathROUND — Round a number to specified decimal placesMathARRAYFORMULA — Apply a formula to an entire column (Google Sheets)Math

Need a formula that's not here?

Generate custom formula →