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) (Robot: Automated text replacement %s)
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:
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