We’re improving Formula Genius. We’re redesigning the app and fixing issues along the way. Sorry for any disruption, and thank you for your patience.
Excel beginner

SUMIFS With Multiple Conditions in Excel

SUMIFS lets you sum a range based on 2, 3, or more criteria. It's the workhorse formula for financial analysis and reporting.

Formula Genius can generate a draft from a plain-English prompt. Supported formulas can be checked with sample cases; review the coverage on the result.

Generate this formula Browse library

The formula

Prompt

"Sum sales amounts where the region is West and the date is in Q1 2026"

Excel 
=SUMIFS(C2:C100,A2:A100,"West",B2:B100,">="&DATE(2026,1,1),B2:B100,"<"&DATE(2026,4,1))

SUMIFS adds values in the sum range (C2:C100) only where ALL criteria are met: region equals West AND date falls within Q1 2026 (January 1 through March 31).

Step-by-step breakdown

  1. C2:C100 is the sum range — the values to add up
  2. A2:A100,"West" — first criteria: region must be West
  3. B2:B100,">="&DATE(2026,1,1) — second criteria: date on or after Jan 1
  4. B2:B100,"<"&DATE(2026,4,1) — third criteria: date before Apr 1
  5. Using < April 1 instead of <= March 31 correctly handles timestamps

Edge cases & warnings

  • Date comparisons with times: using < April 1 catches March 31 at any time
  • Text criteria are case-insensitive by default
  • Wildcards (* and ?) work in text criteria
  • Empty cells in the sum range are treated as 0
  • Returns 0 (not #N/A) when no rows match — no error handling needed

Examples

Prompt

"Region="West", Date in Q1 2026"

Excel 
Sum of all West region sales in Jan-Mar 2026
Prompt

"Region="East", Date in Q2 2026"

Excel 
Modify criteria range values to get East Q2 totals

Frequently asked questions

What is the SUMIFS Excel formula used for?

SUMIFS adds numbers only when every condition you specify is true. It is commonly used for finance reports, sales summaries, budget tracking, and any multi-criteria spreadsheet calculation.

What's the difference between SUMIF and SUMIFS?

SUMIF handles one condition. SUMIFS handles multiple conditions. Always use SUMIFS — it works with one condition too and has a more consistent argument order.

Can SUMIFS handle OR logic?

Not directly. For OR conditions, use SUMPRODUCT or add multiple SUMIFS together. For example: =SUMIFS(...,"East")+SUMIFS(...,"West") for East OR West.

Can't find what you need?

Describe a formula in plain English. Formula Genius drafts and explains it, and can check supported formulas on sample cases.

Generate custom formula See examples