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.