Excel SUM Function: How to Use It, with Examples
Turkish: TOPLA

Adds up the numbers in the cells you select.

SUM syntax

=SUM(number1, [number2])

In Turkish Excel: =TOPLA(sayı1; [sayı2])

ArgumentDescription
number1The first number or range to add.
[number2]Additional numbers or ranges.

SUM examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=SUM(C2:C6)
Result: 62

Adds up all quantities.

=SUM(C2:C3,C5)
Result: 25

Several ranges and cells can be added together.

Results were calculated in real Excel.

Tips for SUM

  • Shortcut: Alt + = inserts SUM below the selected cells.
  • Cells containing text are ignored.

Related functions

More formula guides

More tools

About SUM Function

Adds up the numbers in the cells you select.

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 SUM Function

  1. Type the formulaStart typing =SUM( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is SUM in Turkish Excel?

In Turkish Excel, SUM is called TOPLA. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have SUM?

SUM is available in all current Excel versions (2010 and later, Microsoft 365).