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/01/func_sum.xhp | 48 ++++++++++++++++++++++++++ 1 file changed, 48 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/func_sum.xhp (limited to 'helpcontent2/source/text/scalc/01/func_sum.xhp') diff --git a/helpcontent2/source/text/scalc/01/func_sum.xhp b/helpcontent2/source/text/scalc/01/func_sum.xhp new file mode 100644 index 000000000..04003fb75 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/func_sum.xhp @@ -0,0 +1,48 @@ + + + + + + + SUM Function + /text/scalc/01/func_sum.xhp + + + +

+ + + SUM function + adding;numbers in cell ranges + +

SUM

+ Adds a set of numbers. +

+ +

+ SUM() +

+ =SUM(2;3;4) returns 9. + =SUM(A1;A3;B5) calculates the sum of the three cells. + =SUM(A1:E10) calculates the sum of all cells in the A1 to E10 cell range. + A formula such as =SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40) may be entered as an array formula by pressing the Shift+Command+Ctrl+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum. + Refer to the SUM wiki page for more details about this function. + +

+ + , + + +

+ + + \ No newline at end of file -- cgit v1.2.3