Difference between revisions of "FR/Documentation/Calc:Fonction SOUS.TOTAL"
From Apache OpenOffice Wiki
< FR | Documentation
m (Catégorie et paramètre de tri.) |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 5: | Line 5: | ||
=== Syntaxe: === | === Syntaxe: === | ||
| − | <tt>'''SOUS.TOTAL(fonction; | + | <tt>'''SOUS.TOTAL(fonction; plage)'''</tt> |
| − | : <tt>''' | + | : <tt>'''plage'''</tt> is the overall range from which cells for calculation are selected by filtering. |
| − | : <tt>''' | + | : <tt>'''fonction'''</tt> est un nombre qui designe la fonction a calculer comme suit : |
{| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" | {| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" | ||
| − | !<tt>''' | + | !<tt>'''fonction'''</tt>||Fonction |
|- | |- | ||
|align="center"|1||AVERAGE | |align="center"|1||AVERAGE | ||
| Line 38: | Line 38: | ||
: If <tt>'''range'''</tt> contains other <tt>'''SUBTOTAL'''</tt> functions they are ignored to avoid double counting. | : If <tt>'''range'''</tt> contains other <tt>'''SUBTOTAL'''</tt> functions they are ignored to avoid double counting. | ||
| − | === | + | === Exemple: === |
[[Image:Calc_subtotal_example.png|right|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. | 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. | ||
| Line 63: | Line 63: | ||
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | '''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | ||
[[en:Documentation/How Tos/Calc: SUBTOTAL function]] | [[en:Documentation/How Tos/Calc: SUBTOTAL function]] | ||
| + | [[Category: Calc/Fonctions/FR|SOUS.TOTAL]] | ||
Latest revision as of 12:13, 6 May 2009
SOUS.TOTAL
Renvoi la valeur SOMME, MOYENNE, STDEV, etc. sur des données filtrées.
Syntaxe:
SOUS.TOTAL(fonction; plage)
- plage is the overall range from which cells for calculation are selected by filtering.
- fonction est un nombre qui designe la fonction a calculer comme suit :
| fonction | Fonction |
|---|---|
| 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.
Exemple:
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
