Google Sheets-Funktion

SUBTOTAL

Returns a subtotal in a list or database.

Formel mit KI erstellen Dieselbe Funktion in Excel

Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.

Syntax

SUBTOTAL(function_num, ref1, …)

The SUBTOTAL function is unique because it can ignore hidden rows and nested subtotals. It uses a function number to determine which calculation to perform, such as SUM, AVERAGE, or COUNT.

Argumente

function_numerforderlichA number 1-11 or 101-111 that specifies which function to use for the subtotal.
ref1erforderlichThe range or reference to subtotal.

Beispiele

=SUBTOTAL(9, A1:A10)

Ergebnis: 500

Calculates the sum of cells A1 through A10, ignoring any other subtotals within that range.

FAQ

What is the difference between 9 and 109 as function_num?

9 includes hidden rows in the calculation, while 109 ignores rows that are manually hidden.

SUBTOTAL

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen

SUBTOTAL

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen