Excel kılavuzu

How to use the SUBTOTAL function in Excel

The SUBTOTAL function is essential for dynamic reporting because it ignores hidden rows, unlike the standard SUM function. It allows you to perform calculations on only the visible data in your filtered lists.

Bunun yerine yapay zekâ ile yap

Adım adım

1
Select the cell for your total
Click on the cell where you want the result to appear, typically at the bottom of your data column.
2
Enter the SUBTOTAL formula
Type '=SUBTOTAL(' followed by the function number (e.g., 9 for SUM) and a comma.
3
Define the data range
Select the range of cells you want to calculate, close the parenthesis, and press Enter.

=SUBTOTAL(9, A2:A100)

İpuçları

Use function number 109 instead of 9 if you want to ignore manually hidden rows as well as filtered rows.

SSS

Neden SUM yerine SUBTOTAL kullanılmalı?

SUM includes all rows in a range even if they are hidden by a filter, whereas SUBTOTAL only calculates the visible rows.

İlgili kılavuzlar

Excel'de ETOPLA ve ETOPLA Nasıl Kullanılır