Difference between revisions of "FR/Documentation/Calc:Fonction SOUS.TOTAL"

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
  
== SUBTOTAL ==
+
== SOUS.TOTAL==
Returns SUM, AVERAGE, STDEV, etc. results for filtered data.
+
Renvoi la valeur SOMME, MOYENNE, STDEV, etc. sur des données filtrées.
  
=== Syntax: ===
+
=== Syntaxe: ===
<tt>'''SUBTOTAL(function; range)'''</tt>
+
<tt>'''SOUS.TOTAL(fonction; portée)'''</tt>
: <tt>'''range'''</tt> is the overall range from which cells for calculation are selected by filtering.
+
: <tt>'''portée'''</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:
 
: <tt>'''function'''</tt> is a number that specifies the function to calculate, as follows:

Revision as of 20:24, 29 April 2008


SOUS.TOTAL

Renvoi la valeur SOMME, MOYENNE, STDEV, etc. sur des données filtrées.

Syntaxe:

SOUS.TOTAL(fonction; portée)

portée 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:

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

Mathematical functions

Personal tools
In other languages