SUMIFS Formula Example (With Multiple Criteria) – Complete 2026 Guide

SUMIFS Formula Example (With Multiple Criteria)

The SUMIFS formula in Excel allows you to sum values based on multiple conditions. It’s one of the most powerful functions in Excel for finance, reporting, and data analysis.

If you’ve ever searched for:

• SUMIFS formula example

• SUMIFS multiple criteria

• How to use SUMIFS in Excel

This guide will walk you through everything step-by-step.

What Is the SUMIFS Formula?

SUMIFS adds numbers in a range that meet specific conditions.

Syntax:

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Example: Sum Sales by Region and Month

SalesRegionMonth500WestJan300EastJan700WestFeb

To sum sales where:

Region = "West"
Month = "Jan"

Formula:

=SUMIFS(A2:A4, B2:B4, "West", C2:C4, "Jan")

Result: 500

Common SUMIFS Errors

• Mismatched ranges

• Text vs number formatting issues

• Criteria typed incorrectly

• Using SUMIF instead of SUMIFS

This is why many users spend 10–15 minutes debugging a single formula.

Faster Way: Generate SUMIFS Instantly

Instead of writing:

=SUMIFS(A2:A100, B2:B100, "West", C2:C100, "Jan")

You can simply type:

“Sum sales where region is West and month is Jan.”

And generate the correct formula instantly using SheetAI.

👉 Try the Google Sheets Formula Generator here:
https://smartsideai.lovable.app