|
06030000.xhp
tit
help.text
|
Sum
|
|
|
06030000.xhp
bm_id3157909
help.text
|
<bookmark_value>functions;sum function icon</bookmark_value> <bookmark_value>formula bar;sum function</bookmark_value> <bookmark_value>sum icon</bookmark_value> <bookmark_value>AutoSum button, see sum icon</bookmark_value>
|
|
|
06030000.xhp
hd_id3157909
help.text
|
<link href="text/scalc/02/06030000.xhp" name="Sum">Select Function</link>
|
|
|
06030000.xhp
par_id3150543
help.text
|
<ahelp hid="HID_INSWIN_SUMME">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.</ahelp>
|
|
|
06030000.xhp
par_id3153770
help.text
|
<image id="img_id3147434" src="cmd/sc_autosum.svg" width="1cm" height="1cm"><alt id="alt_id3147434">Icon Select Function</alt></image>
|
|
|
06030000.xhp
par_id3152577
help.text
|
Select Function
|
|
|
06030000.xhp
hd_id161592658402954
help.text
|
Select Function applied with no selected range
|
|
|
06030000.xhp
par_id3156444
help.text
|
$[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.
|
|
|
06030000.xhp
par_id3153189
help.text
|
Click the <emph>Accept</emph> icon to use the formula displayed in the input line or <emph>Cancel</emph>.
|
|
|
06030000.xhp
par_id231592663499228
help.text
|
<image src="cmd/sc_ok.svg" id="img_id521592663499228" width="1cm" height="1cm"><alt id="alt_id171592663499228">Accept Icon</alt></image>
|
|
|
06030000.xhp
par_id481592663499228
help.text
|
Accept
|
|
|
06030000.xhp
par_id311592663828848
help.text
|
<image src="cmd/sc_cancel.svg" id="img_id641592663828848" width="1cm" height="1cm"><alt id="alt_id111592663828848">Icon Cancel</alt></image>
|
|
|
06030000.xhp
par_id431592663828848
help.text
|
Cancel
|
|
|
06030000.xhp
hd_id261592658395518
help.text
|
Select Function applied on a selected range
|
|
|
06030000.xhp
par_id911592658130888
help.text
|
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.
|
|
|
06030000.xhp
par_id991592658144387
help.text
|
When the selected range has one row, the function result is placed in the first available cell on the right of the selected range.
|
|
|
06040000.xhp
tit
help.text
|
Function
|
|
|
06040000.xhp
bm_id3150084
help.text
|
<bookmark_value>formula bar; functions</bookmark_value><bookmark_value>functions; formula bar icon</bookmark_value>
|
|
|
06040000.xhp
hd_id3150084
help.text
|
<link href="text/scalc/02/06040000.xhp" name="Function">Function</link>
|
|
|
06040000.xhp
par_id3151245
help.text
|
<ahelp hid="HID_INSWIN_FUNC">Adds a formula to the current cell. Click this icon, and then enter the formula in the <emph>Input line</emph>.</ahelp>
|
|
