Documentation/SL/How Tos/Calc: funkcija SUBTOTAL

From Apache OpenOffice Wiki
< Documentation‎ | SL/How Tos
Revision as of 11:58, 24 November 2009 by OOoWikiBot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


SUBTOTAL

Vrne rezultate funkcij SUM, AVERAGE, STDEV, itn. za filtrirane podatke.

Skladnja:

SUBTOTAL(funkcija; obseg)

obseg is the overall range from which cells for calculation are selected by filtering.
funkcija is a number that specifies the function to calculate, as follows:
funkcija Funkcija
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP
Če vsebuje obseg druge funkcije SUBTOTAL, so te prezrte, da se izognemo dvojnemu štetju.

Primer:

primer

You have a table in the cell range A1:B5 containing cities in column A and accompanying figures in column B. You have used an AutoFilter so that you only see rows containing the city Hamburg. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows.

SUBTOTAL(9; B1:B5)

vrne želeni rezultat.


Glejte tudi:

AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR, VARP,

Filtriranje obsegov celic

Matematične funkcije

Personal tools
In other languages