fx =SUMIF(A1:A100,"Completed",B1:B100)ABCQ1 Sales$42,500$170,000Q2 Sales$38,200Q3 Sales$51,800
📊 Math

SUMIF Formula for Math

Sum values that meet a single condition. Copy-paste ready for Excel, Google Sheets, and Airtable.

=SUMIF(A1:A100,"Completed",B1:B100)
When you need this: When you need to total revenue only from "Completed" orders (status in A1:A100, amounts in B1:B100).

How it works

  1. 1Check each cell in the range (A1:A100) against the criterion ("Completed").
  2. 2When a match is found, add the corresponding value from the sum range (B1:B100).
  3. 3Return the total of all matching amounts.

Variations

SUMIF with numeric criteria
=SUMIF(A1:A100,">1000",B1:B100)
SUMIF with wildcard text
=SUMIF(A1:A100,"*North*",B1:B100)

Related Formulas

SUM — Add up a range of numbersMathSUMIFS — Sum values meeting multiple conditionsMathROUND — 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 →