Excel SUMIFS function🔀 Sum with several conditions

The SUMIFS function: Sum with several conditions. Sales for this branch, this month. This page shows the syntax, a worked example with its result and how the formula reads.

What does SUMIFS do?

Sum with several conditions. Sales for this branch, this month

SUMIFS syntax

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

Arguments in square brackets [ ] are optional · argument names follow Microsoft's documentation

SUMIFS example with the result

=********

👑 Ready-to-use example formula for VIP supporters only · Become VIP

Formula in cell C6 Yellow cells = result

ABC
1BranchMonthSales
2BangnaJan500
3BangnaFeb300
4SilomJan200
5BangnaJan100
6Bangna Jan600

How it reads: Adds column C where branch is Bangna and month is Jan (500 + 100) · the sum range comes first

Frequently asked questions about SUMIFS

What does SUMIFS do?

Sum with several conditions. Sales for this branch, this month

What does the SUMIFS example return?

The example formula in cell C6 gives 600.

Which Excel versions have SUMIFS?

It has been in Excel for many versions and works in the versions in common use today, including Excel for Microsoft 365.

Source: support.microsoft.com

Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning

🤖
Posting...
Please wait a moment
Social VIP Classroom
Home
Thai Smiles Profile