Select Function
Insert a function of a cell range into the current cell. The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell, click this icon, select the function in the drop down list and optionally adjust the cell range. Or select some cells into which the function value will be inserted, then click the icon. The function result is added at the bottom of the range.
Vælg funktion
Select Function applied with no selected range
$ [officename] foreslår automatisk et celleområde, forudsat at regnearket indeholder data. Hvis celleområdet allerede indeholder en funktion, kan du kombinere den med den nye for at give den funktion, der er anvendt til områdedataene. Hvis området indeholder filtre, indsættes den subtotale funktion i stedet for den valgte funktion.
Click the Accept icon to use the formula displayed in the input line or Cancel.
Accepter
Cancel
Select Function applied on a selected range
When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column.
When the selected range has one row, the function result is placed in the first available cell on the right of the selected range.