Excel SUBTOTAL Function: How to Use It, with Examples
Turkish: ALTTOPLAM

Returns the sum, average and so on of only the visible rows in a filtered list.

SUBTOTAL syntax

=SUBTOTAL(function_num, ref1)

In Turkish Excel: =ALTTOPLAM(işlev_sayısı; başv1)

ArgumentDescription
function_num9 = sum, 1 = average, 3 = count non-empty; add 100 to also exclude manually hidden rows.
ref1Range.

SUBTOTAL examples

Sample table:

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

Sum of visible rows.

Results were calculated in real Excel.

Related functions

More formula guides

More tools

About SUBTOTAL Function

Returns the sum, average and so on of only the visible rows in a filtered list.

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

  1. Type the formulaStart typing =SUBTOTAL( 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 SUBTOTAL in Turkish Excel?

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

Which Excel versions have SUBTOTAL?

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