The functions will certainly come in handy when you need some values from data table cells that match specified conditions.This is a step by step tutorial to make LibreOffice Calc macro examples with SUM function. You can also select SUMIFS, COUNTIFS and AVERAGEIFS functions to set up functions based on multiple conditions. Those are four of the conditional functions you can add to your Calc spreadsheet. That will find the average of the cell values in the spring rows. Enter “spring” in the criteria box, and select the cells with the numbers in them for the average_range text box. Then select the cells in the row that includes the text for the AVERAGEIF function’s range box.

For example, enter some text into an adjacent column on the spreadsheet as below. You can also set up a condition based on text in another column or row.

The 139 and 123 values amount to 162 that divides by two to equal 131. That’s the average of the two cells values in the column lower than 145. Now the AVERAGEIF cell should have a value of 131. Select the same cells as the range box for the average_range box. Press the Select button beside the range box to select the cells you entered numbers into. That will open the AVERAGEIF wizard to set up the function with. Select a cell for the AVERAGEIF function, open the Function Wizard and select AVERAGEIF. Alternatively, you could also base the condition on a row or column heading.Įnter a few numbers into a spreadsheet row exactly as in the snapshot directly below. So you could find the average value of cells that eclipse or are lower than a specific number. The AVERAGEIF function is similar to SUMIF except it finds the average value of cells based on a specific condition.

Libreoffice basic examples