SUMIFS in Excel: Complete Guide with Examples | SheetXAI

The Problem

You need to sum revenue, but only for sales in the 'East' region AND only for products that are 'Active'. A single SUMIF can't handle multiple conditions.

The Easy Way: Use SheetXAI

If you don't want to mess with formulas, the fastest way to do this is simply by asking.

With SheetXAI, you can open the sidebar and type:

Sum the revenue for all sales where region is 'East' and status is 'Active'.

SheetXAI will instantly write the formula or script for you and fill the cells. It handles the syntax so you can focus on the result.

The Manual Way: The Formulas You Need

To do this manually, you need to use: SUMIFS.

1. SUMIFS

Adds the cells specified by multiple conditions. This is the multi-criteria version of SUMIF.

Syntax: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

• sum_range: The range of cells to sum (the actual values you want to add).
• criteria_range1: The first range to evaluate against criteria1.
• criteria1: The first condition that must be met (e.g., 'East', '>100', 'Active').
• [criteria_range2, criteria2]: Additional range-condition pairs (optional, can add many).

Example: Sum Revenue column where Region is 'East' AND Status is 'Active'.

Understanding the Logic

1. Sum range: The column with values to add (Revenue).
2. First condition: Check Region column for 'East'.
3. Second condition: Check Status column for 'Active'.
4. Result: Only sums Revenue where BOTH conditions are true.

You can add as many conditions as needed - all must be true for a row to be included in the sum.

The Final Formula:

=SUMIFS(C:C, A:A, "East", B:B, "Active")

Conclusion

Now you know the "classic" way to solve this using formulas. It's a great skill to have.

But for those times when you just want the job done without the mental math, SheetXAI is there to help.

Related Guides

• SUMIF in Excel - Sum with a single condition
• COUNTIFS in Excel - Count cells with multiple criteria
• Excel AI Guide - Learn how AI can automate your Excel workflows
• AI Spreadsheet Tools - Discover how AI transforms spreadsheet work