Documentation/Calc Functions/SUBTOTAL/da

Funktionsnavn:
SUBTOTAL

Kategori:
Matematisk

Resume:
Beregner subtotaler. Hvis et område allerede indeholder subtotaler, bruges de ikke til videre beregninger. Brug denne funktion med Autofiltre til kun at tage de filtrerede poster i betragtning.

If the data range processed by SUBTOTAL already contains any subtotals, these are ignored to avoid counting values twice. If any row within the data range is filtered out, its data is ignored by SUBTOTAL. SUBTOTAL can optionally include or exclude data from rows within the data range that have been manually hidden.

Syntaks:
SUBTOTAL(funktion; område)

Returnerer:
Returnerer en reelt værdi, som er subtotalen på en liste eller i en database.

Argumenter:
Funktion er et heltal eller en reference til cellen, der indeholder det heltal. der står for en af følgende funktioner:

Område er referencen til den celle, der medtages.


 * Hvis tallet ikke er 1-11 eller 101-111, returnerer funktionen en værdifejl.
 * Hvis en vilkårlig celle i området ikke indeholder en numerisk værdi, ignoreres denne celle.

Yderligere oplysninger:
Ingen


 * Hiding columns has no impact on the results produced by the SUBTOTAL function.


 * See their individual pages for more details about each of the eleven possible subtotal functions.

Eksempler:
Du har en tabel i celleområdet A1:B6, der indeholder en materialeoversigt for 10 studerende. Række 2 (Pen) er skjult manuelt. Du vil se det viste, samlede antal; dvs. bare subtotalen af de filtrerede rækker. I dette tilfælde er den korrekte formel:

The students' names are listed in alphabetical order in cells A2:A13 and their scores are listed in cells B2:B13. The asterisk (*) in cell B5 indicates that James was absent and unable to take the test. The following examples are based on the data in the above table.

For the following examples the same data table is used but row 2 is hidden (by right-clicking on the row number and selecting Hide Rows from the context menu).

For the final examples, the data table is reverted to its original state by unhiding row 2 (by selecting the row numbers for rows 1 and 3, right-clicking on either of the selected row numbers, and selecting Show Rows from the context menu). Then AutoFilters are applied by left-clicking within the cell range A1:B13 and then selecting on the Menu bar. Finally press the down arrow in the Score column heading, untick the check box next to the number 10 near the bottom of the dialog, and press the Accept button. Rows 3 and 7 are now filtered out.

Beslægtede LibreOffice-funktioner:
AVERAGE

COUNT

COUNTA

MAX

MIN

PRODUCT

STDEV

STDEVP

SUM

VAR

VARP

ODF standard:
Section 6.16.60, part 2

Tilsvarende Excel-funktioner:
SUBTOTAL