OpenOffice3.org Calc 3. Mathematical Functions
Función SUBTOTAL(Function; range)
Returns a numeric value. Given a set of
values, calculates the result of these values, depending on the choice made in
the argument “Function”. For example, you can add the values given, determine
the minimum, determine the maximum, and so on. This function take two arguments.
The argument “Function” determines the type of calculation to be made with
values. This argument can take an integer numeric value greater than or equal to
1 and less than or equal to 11. In the table right away, shows the possible
values that can the role. The argument “range” includes reference to a range of
cells, indicating the values used to calculate the result.
Argument "Function" | Function used | Description |
1 | AVERAGE | Calculates the average of the values given. |
2 | COUNT | Returns the number of cells that contains a numeric value. |
3 | COUNTA | Returns the number of cells that are not empty. |
4 | MAX | Returns the maximum value found in the range. |
5 | MIN | Returns the minimum value on the range. |
6 | PRODUCT | Calculates the product of the values. |
7 | STDEV | Calculates the standard deviation of the values given. |
8 | STDEVP | Calculates the standard deviation of the population. |
9 | SUM | Returns the sum of the values given. |
10 | VAR | Calculates the variance of the values given. |
11 | VARP | Calculates the variance of the population. |
Por ejemplo:
=SUBTOTAL(5;A1:B5) Returns the minimum value found in the range A1:B5.
=SUBTOTAL(4;A12:C19) Returns the maximum value found in the range A12:C19.