Excel SUMIF Function: How to Use It, with Examples Turkish: ETOPLA
Adds the values in rows that meet one condition, for example only the sales from Ankara.
SUMIF syntax
=SUMIF(range, criteria, [sum_range])
In Turkish Excel: =ETOPLA(aralık; ölçüt; [toplam_aralığı])
Argument
Description
range
The cells to test against the condition.
criteria
The condition (e.g. "Ankara", ">10").
[sum_range]
The cells to add; if omitted, range is added.
SUMIF 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
=SUMIF(B2:B6,"Ankara",C2:C6)
Result: 47
Total quantity in Ankara.
=SUMIF(C2:C6,">10")
Result: 42
Sum of quantities greater than 10.
Results were calculated in real Excel.
Tips for SUMIF
Use SUMIFS for multiple conditions.
Put criteria with comparison operators in quotes: ">10".
Related functions
More formula guides
More tools
About SUMIF Function
Adds the values in rows that meet one condition, for example only the sales from Ankara.
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 SUMIF Function
Type the formulaStart typing =SUMIF( 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 SUMIF in Turkish Excel?
In Turkish Excel, SUMIF is called ETOPLA. Turkish Excel also separates arguments with semicolons (;) instead of commas.
Which Excel versions have SUMIF?
SUMIF is available in all current Excel versions (2010 and later, Microsoft 365).