Excel SUMIFS Function: How to Use It, with Examples Turkish: ÇOKETOPLA
Adds the values in rows that meet all of several conditions.
SUMIFS syntax
=SUMIFS(sum_range, criteria_range1, criteria1, …)
In Turkish Excel: =ÇOKETOPLA(toplam_aralığı; ölçüt_aralığı1; ölçüt1; …)
Argument
Description
sum_range
The cells to add (first!).
criteria_range1
The cells for the first condition.
criteria1
The first condition.
…
More range/criteria pairs.
SUMIFS examples
Sample table:
A
B
C
D
1
Product
Region
Quantity
Price
2
Pen
Ankara
12
5
3
Notebook
İzmir
8
20
4
Eraser
Ankara
30
2
5
Notebook
Ankara
5
20
6
Pen
İzmir
7
5
=SUMIFS(C2:C6,B2:B6,"Ankara",A2:A6,"Notebook")
Result: 5
Quantity of notebooks in Ankara.
Results were calculated in real Excel.
Tips for SUMIFS
Unlike SUMIF, the range to add is the first argument.
Related functions
More formula guides
More tools
About SUMIFS Function
Adds the values in rows that meet all of several conditions.
Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.
How to use SUMIFS Function
Type the formulaStart typing =SUMIFS( in a cell; Excel shows the arguments.
Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
Press EnterCheck the result; you can also try it in the tester below.
Frequently asked questions
What is SUMIFS in Turkish Excel?
In Turkish Excel, SUMIFS is called ÇOKETOPLA. Turkish Excel also separates arguments with semicolons (;) instead of commas.
Which Excel versions have SUMIFS?
SUMIFS is available in all current Excel versions (2010 and later, Microsoft 365).