OpenOffice3.org Calc 3. Mathematical Functions

SUMIF(range; criteria; sum_range) Function

Calculates the sum of numeric values in a range of cells, depending on the fulfillment of the given condition. This function returns a numeric value. This function returns a numeric value. The argument “range” includes reference to a range of cells, indicating the range in which to evaluate the condition. The argument “criteria” may contain a constant, expression or reference to a cell containing the condition. The argument “sum_range” is optional, contains a reference to a range of cells, indicating the cells used to add the values, depending on the condition established. If you omit the argument “sum_range”, the function adds the values present in the range indicated by the argument “range” as long as it meets the condition. Look at this example for understand better this function.

=SUMIF(A2:A6;"red";B2:B6) The argument “range” corresponds to the range A2:A6. The argument “criteria” is the text “red”. The argument “sum_range” corresponds to the range B2:B6. The function checks the range A2:A6 to see which cells contain the text “red”. The cells which fulfill the condition used to determine which cells in the range B2:B6 are included in the sum the contents of cell B3. So on for all cells in the range.

Back to the list of mathematical functions