Difference between revisions of "FR/Documentation/Calc:Fonction SOUS.TOTAL"
From Apache OpenOffice Wiki
< FR | Documentation
(New page: fgfdgdfg) |
|||
Line 1: | Line 1: | ||
− | + | __NOTOC__ | |
+ | |||
+ | == SUBTOTAL == | ||
+ | Returns SUM, AVERAGE, STDEV, etc. results for filtered data. | ||
+ | |||
+ | === Syntax: === | ||
+ | <tt>'''SUBTOTAL(function; range)'''</tt> | ||
+ | : <tt>'''range'''</tt> is the overall range from which cells for calculation are selected by filtering. | ||
+ | |||
+ | : <tt>'''function'''</tt> is a number that specifies the function to calculate, as follows: | ||
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" | ||
+ | !<tt>'''function'''</tt>||Function | ||
+ | |- | ||
+ | |align="center"|1||AVERAGE | ||
+ | |- | ||
+ | |align="center"|2||COUNT | ||
+ | |- | ||
+ | |align="center"|3||COUNTA | ||
+ | |- | ||
+ | |align="center"|4||MAX | ||
+ | |- | ||
+ | |align="center"|5||MIN | ||
+ | |- | ||
+ | |align="center"|6||PRODUCT | ||
+ | |- | ||
+ | |align="center"|7||STDEV | ||
+ | |- | ||
+ | |align="center"|8||STDEVP | ||
+ | |- | ||
+ | |align="center"|9||SUM | ||
+ | |- | ||
+ | |align="center"|10||VAR | ||
+ | |- | ||
+ | |align="center"|11||VARP | ||
+ | |} | ||
+ | |||
+ | : If <tt>'''range'''</tt> contains other <tt>'''SUBTOTAL'''</tt> functions they are ignored to avoid double counting. | ||
+ | |||
+ | === Example: === | ||
+ | [[Image:Calc_subtotal_example.png|right|example]] | ||
+ | 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 <tt>'''Hamburg'''</tt>. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. | ||
+ | |||
+ | <tt>'''SUBTOTAL(9; B1:B5)'''</tt> | ||
+ | : returns the desired result. | ||
+ | <br clear="all" /> | ||
+ | |||
+ | === See also: === | ||
+ | '''[[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: COUNT function|COUNT]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: COUNTA function|COUNTA]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: MAX function|MAX]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: MIN function|MIN]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: STDEV function|STDEV]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: STDEVP function|STDEVP]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: SUM function|SUM]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: VAR function|VAR]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: VARP function|VARP]]''', | ||
+ | |||
+ | '''Filtering Cell Ranges''' | ||
+ | |||
+ | '''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' |
Revision as of 18:57, 29 April 2008
SUBTOTAL
Returns SUM, AVERAGE, STDEV, etc. results for filtered data.
Syntax:
SUBTOTAL(function; range)
- range is the overall range from which cells for calculation are selected by filtering.
- function is a number that specifies the function to calculate, as follows:
function | Function |
---|---|
1 | AVERAGE |
2 | COUNT |
3 | COUNTA |
4 | MAX |
5 | MIN |
6 | PRODUCT |
7 | STDEV |
8 | STDEVP |
9 | SUM |
10 | VAR |
11 | VARP |
- If range contains other SUBTOTAL functions they are ignored to avoid double counting.
Example:
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)
- returns the desired result.
See also:
AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR, VARP,
Filtering Cell Ranges