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