You can create multiple selections to obtain automatic function values (means, sums, quartiles etc.) for selected cells.

• Using mouse:

  To add subsequent cells/ranges to such a multiple selection, press Ctrl and click the desirable cell or select a range.

  The table toolbar will display the "combined cells" label before the function values and the current combined references will be shown as a list in the composer toolbar edit field.

  

  To reset the current combined list of cells, click the sheet without Ctrl or press/release SHIFT.

• Using keyboard

  To perform such selections using the keyboard only, press Ctrl + Numpad0 to add the current selection to the list.

  Adding the same selection twice quits the selecting mode and all made selections.

To copy the calculated values, right-click the table toolbar: the values are copied in one column or two columns if copied with labels, like

    407.25
    27.15
    9.2
    81

    sum		407.25
    average	27.15
    min		9.2
    max		81

To select a different set of functions to calculate, click the table toolbar to display its options: