ExcelFlux

SUMIFS function

SUMIFS adds values from rows that meet every criterion.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Total invoices matching a region and a payment status. The sum range is the first argument.

A worked example from the workbook

RowABC
6RegionStatusAmount
7NorthPaid120
8SouthPaid75
9NorthOpen40
10NorthPaid80
11SouthOpen0
North / Paid
=SUMIFS(C7:C11,A7:A11,"North",B7:B11,"Paid")

Expected result200

See the inputs and instructions for all 3 examples

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, …)

Copyable formulas

English Excel · en-US
=SUMIFS(C2:C5,A2:A5,E3,C2:C5,">="&E4)
Turkish Excel · tr-TR
=ÇOKETOPLA(C2:C5;A2:A5;E3;C2:C5;">="&E4)

Sample data

Enter the headers and sample records in A1:C5.

Team Date Net hours
Warehouse 2 Nov 2026 8
Warehouse 3 Nov 2026 6
Field 4 Nov 2026 9
Warehouse 5 Nov 2026 7.5
  • E3 = Warehouse
  • E4 = 7

Enter the formula in E2.

To try the Turkish formula, use the sample data on the Turkish page.

Expected result

15.5

How it works

The first range supplies the values to sum. Each later range-and-criterion pair applies to the same row. Change the threshold in E4 to 8 and the total becomes 8. No matches return 0.

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, …)

Compatibility

Excel for Microsoft 365 and Excel 2016, 2019, 2021, and 2024.

Worked examples

Total invoices matching a region and a payment status. The sum range is the first argument.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Region Status Amount
7 North Paid 120
8 South Paid 75
9 North Open 40
10 North Paid 80
11 South Open 0
Case Formula Expected result
North / Paid =SUMIFS(C7:C11,A7:A11,"North",B7:B11,"Paid") 200
North / Open =SUMIFS(C7:C11,A7:A11,"North",B7:B11,"Open") 40
South / Overdue =SUMIFS(C7:C11,A7:A11,"South",B7:B11,"Overdue") 0
Microsoft Excel reference