From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/02/06030000.xhp | 86 ++++++++++++++++++++++++++ 1 file changed, 86 insertions(+) create mode 100644 helpcontent2/source/text/scalc/02/06030000.xhp (limited to 'helpcontent2/source/text/scalc/02/06030000.xhp') diff --git a/helpcontent2/source/text/scalc/02/06030000.xhp b/helpcontent2/source/text/scalc/02/06030000.xhp new file mode 100644 index 000000000..cbc1f81b9 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06030000.xhp @@ -0,0 +1,86 @@ + + + + + + + + + Sum + /text/scalc/02/06030000.xhp + + + +
+functions;sum function icon + formula bar;sum function + sum icon + AutoSum button, see sum icon + +MW inserted a cross-reference +

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. +
+
+ + + + +Icon Select Function + + + + Select Function + + +
+
+

Select Function applied with no selected range

+$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function. + Click the Accept icon to use the formula displayed in the input line or Cancel. + + + + +Accept Icon + + + + Accept + + +
+ + + + +Icon Cancel + + + + 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. + + -- cgit v1.2.3