ExamplesFor You
Home / Excel / SUMIFS
✍️ Excel summary examples

SUMIFS Examples in Excel

Learn SUMIFS examples for totals by date, category, region, status and multiple criteria.

Updated 2026-06-125 practical examplesCopy-ready

What it does

SUMIFS totals values that match multiple conditions.

Syntax or pattern

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

5 practical examples

1

Total by region and product

Sum sales for East region and Coffee product.

=SUMIFS(Sales[Amount],Sales[Region],"East",Sales[Product],"Coffee")

Each criteria pair narrows the total.

2

Total inside a date range

Sum values between start and end dates.

=SUMIFS(Sales[Amount],Sales[Date],">="&F1,Sales[Date],"<="&G1)

Concatenate comparison operators with date cells.

3

Total by status

Sum open invoice amounts.

=SUMIFS(Invoices[Amount],Invoices[Status],"Open")

A single-condition SUMIFS is also valid.

4

Total excluding a value

Sum amounts where status is not cancelled.

=SUMIFS(Orders[Amount],Orders[Status],"<>Cancelled")

Use <> for not equal.

5

Total by dynamic inputs

Use dropdown cells as criteria.

=SUMIFS(Sales[Amount],Sales[Region],H2,Sales[Month],H3)

Great for dashboard summaries.

Common mistakes to avoid

  • Selecting ranges with different sizes.
  • Using text values where numbers are required.
  • Forgetting how blanks and hidden rows are treated.

Related Excel examples

SUM Examples in ExcelSUMIF Examples in ExcelCOUNT Examples in Excel📊 All Excel examples

FAQ

Can this formula use Excel Tables?

Yes. Structured references often make summary formulas easier to read.

💡 Useful resources

Here are some ideas for you

Optional resources that may help if you are learning formulas, building reports, or working in spreadsheets often.

  • 📘
    Excel formula books

    Practice formulas with structured examples you can keep beside your desk.

    See ideas
  • ⌨️
    Excel shortcut guides

    Build speed with keyboard shortcuts for selection, formatting and navigation.

    See ideas
  • 🔢
    Numeric keypads

    Helpful if you enter many numbers on a laptop or compact keyboard.

    See ideas
  • 🖥️
    External monitors

    Useful for viewing large worksheets, formulas and reference tables side by side.

    See ideas
  • 📒
    Desk notebooks

    Sketch formula logic, report ideas and table structures before building.

    See ideas
  • 💻
    Laptop stands

    Make long spreadsheet sessions more comfortable and ergonomic.

    See ideas

Some links in this section may be affiliate links. Choose only what is useful for your own work.