Cellwise

Conditional function

Excel SUMIFS function

SUMIFS adds up a column but only for rows where all your conditions are true. Use it for questions like "West region sales of laptops" or "sales between two dates". The column to add comes first.

fx=SUMIFS(sum_range, criteria_range1, criteria1, ...)

Arguments

sum_range
The cells to add up.
criteria_range1
The first range to test.
criteria1
The condition for that range, like "West" or ">=1000".

SUMIFS examples

Every result below was calculated live from this sample sheet.

ABCD
1DateRegionProductRevenue
22025-01-14WestLaptop4200
32025-01-20EastLaptop3150
42025-02-03WestMonitor960
52025-02-11WestLaptop2800
62025-02-25EastMonitor1440
72025-03-06WestLaptop5600
  1. fx=SUMIFS(D2:D7,B2:B7,"West",C2:C7,"Laptop")

    Result: 12600

    Laptop revenue in the West region.

  2. fx=SUMIFS(D2:D7,B2:B7,"East")

    Result: 4590

    One condition works too, so SUMIFS can replace SUMIF.

  3. fx=SUMIFS(D2:D7,A2:A7,">="&DATE(2025,2,1),A2:A7,"<"&DATE(2025,3,1))

    Result: 5200

    Revenue for February only, using two date conditions on the same column.

  4. fx=SUMIFS(D2:D7,C2:C7,"Laptop",D2:D7,">3000")

    Result: 12950

    Only large laptop orders, over $3,000 each.

How to use SUMIFS

  1. Click an empty cell.
  2. Type =SUMIFS( and select the column to add.
  3. Add a comma, the first range to test, a comma and its condition.
  4. Add more range, condition pairs as needed.
  5. Close the bracket and press Enter.

Common SUMIFS mistakes

Putting sum_range last

That is SUMIF order. In SUMIFS the column to add always comes first.

Ranges of different sizes

All ranges must be the same size, or SUMIFS returns #VALUE!.

Expecting OR between conditions

SUMIFS needs every condition to be true. For "West or East", add two SUMIFS together.

SUMIFS FAQ

What is the difference between SUMIF and SUMIFS?

SUMIF handles one condition with the sum range last. SUMIFS handles one or many conditions with the sum range first.

How do I sum between two dates in Excel?

Use =SUMIFS(amounts,dates,">="&start,dates,"<="&end), where start and end are cells holding real dates.

Why is SUMIFS returning 0?

One of the conditions never matches. Look for trailing spaces, dates stored as text, or a typo in the criteria.

Can SUMIFS use OR logic?

Not directly. Add separate SUMIFS together, or use =SUM(SUMIFS(D:D,B:B,{"West","East"})).

Practice SUMIFS in these lessons

Guides that use SUMIFS

Related functions

Updated 2026-10-31