Including up rows or columns of figures is definitely one of the almost all common functions transported out in spreadsheet programs like OpenOffice Calc. To make it less complicated to achieve this task, Calc includes a built-in formula known as the Amount function.
of 02
OpenOffice Calc SUM Functionality
Nov 17, 2016. Form as in other spreadsheets such as Excel or Apache OpenOffice. The formula will determine the rectangle of the range and calculate the sum. The SUM function with the range as an argument, and leaves it open for. Calculating With Formulas. From LibreOffice Help. Jump to: navigation, search. Can be used in formulas using the 'Multiplication and Division before Addition and Subtraction' rule. Instead of writing =SUM(A1:B1) you can write =A1+B1. Parentheses can also be used. The result of the formula =(1+2).3 produces a different result than =1+2.3.
- Using the Amount function shortcut button - it is certainly the Ancient greek capital letter Sigma (Σ) located next to theinsight series(exact same as the formula pub in Excel).
- Incorporating the SUM function to a worksheet making use of the function wizard dialog box. The discussion box can end up being opened up by clicking on theFunctionality Sorcererswitch located following to the Sigma switch on theinsight line.
Shortcut and Discussion Box Advantages
The benefit of making use of the Sigma button to get into the functionality is usually that it is quick and easy to use. If the data to become summed is usually grouped collectively in a contiguous variety the functionality will frequently select the range for you.
The advantage of using the Amount function dialog box is definitely if the information to be summed is definitely spread out over a amount of non-contiguous cells. Using the dialog box in this scenario makes it less complicated to include the individual tissue to the functionality.
The Amount Functionality's Syntax and Arguments
A function's syntax refers to the design of the function and contains the function's title, brackets, and arguments.
=Amount (number 1; quantity 2;. number 30)
amount 1; amount 2;. quantity 30- the information to be summed by the functionality. The arguments can consist of:
- a listing of figures to be summed
- a listing of mobile references suggesting the place of the data in the worksheet
- a range of cell personal references to the area of the data
Take note: a maximum of 30 amounts can end up being added by the function.
What the SUM Functionality Ignores
The functionality ignores blank cells and text message data in the chosen range - like quantities that having become formatted as text message.
By default, text information in Calc is usually left aimed in a mobile - as noticed with the quantity 160 in cell A2 in the picture above - amount data aligns to the right by default.
If such text information is later on converted to quantity information or amounts are included to empty tissue in the variety, the Amount function total automatically updates to consist of the brand-new information.
Personally Entering the Amount Functionality
However another option for getting into the function can be to type it into a worksheet cell. If the cell recommendations for the range of information to become summed is recognized, the function can end up being easily inserted manually. For the example in the image above, typing
into cell A7 and pushing theEnterkey on the keyboard would achieve the exact same result as the methods detailed below for making use of the SUM shortcut switch.
Summing Data with the SUM Key
For those who prefer to the mouse to the keyboard, the Amount button is certainly a fast and easy way to enter the Amount function.
When inserted in this style, the functionality tries to figure out the variety of tissue to end up being summed structured on surrounding information and automatically enters the most likely range as the function'samountargument.
The functionality only queries for amount data situated in columns above or in rows to the left of the energetic cell and it ignores text message information and blank tissues.
Below are detailed the methods utilized to enter the SUM function into cell A7 as demonstrated in the picture above.
- Click on on cell A7 to create it the active mobile (the area where the outcomes of the function will end up being displayed)
- Press the Amount switch next to the insight range (as demonstrated in the picture above)
- The Amount function should end up being moved into into the active cell - the function should immediately get into the cell referrals A6 as thequantitydisagreement
- To alter the range of cell references utilized for theamountcase, use the mouse tip to highlight the variety A1 to A6
- Push theEnterkey on the keyboard to full the function
- The reply 417 should end up being shown in the mobile A7
- When you click on cell A7, the comprehensive function= SUM (A1 : A6)seems in theinsight collectionabove the worksheet.
of 02
Add Numbers Making use of Calc'h SUM Functionality Dialog Box
As described, another option for getting into the SUM function is certainly to make use of the functionality's discussion container, which can become opened either by:
- clicking on theFunction Wizardswitch on theinput collectionabove the worksheet.
- pushing the Ctrl + Y2 keys on the keyboard
Discussion Box Advantages
- The dialog box requires care of the function's format - making it less complicated to enter the functionality's quarrels one at a time without getting to get into the similar sign, the mounting brackets, or the semicolons that act as separators between the fights.
- When the data to become summed can be not situated in a contiguous variety, the mobile references, like A new1, A3, and B2:B3 can become easily got into as independentquantitydisputes into the discussion box using pointing - which involve clicking on on selected cells with the mouse rather than keying in them in. Not only is pointing much easier, it furthermore assists to decrease mistakes in recipes caused by wrong cell sources.
SUM Function Example
Beneath are shown the actions utilized to get into the SUM functionality into mobile A7 as shown in the image above. The guidelines use the SUM function dialog package to enter the ideals situated in cells A1, A3, A6, B2, and M3 as amount disputes for the functionality.
- Click on mobile A7 to create it the energetic cell - the place where the results of the function will become displayed
- Click on on theFunctionality Wizardicon following to theinput collection(exact same as the formula pub in Excel) to provide up the Function Wizard dialog package
- Click on into the Type drop-down list and go for Mathematical to notice the list of math features
- Select Amount from the checklist of functions
- Click Next
- Click on on thenumber 1in the discussion container if essential
- Click on cell A1 in the worksheet to enter that cell guide into the dialog package
- Click on on theamount 2in the discussion package
- Click on cell A3 in the worksheet to get into that mobile reference
- Click on on thenumber 3in the dialog package
- Click on mobile A6 in the worksheet to enter that mobile referrals
- Click on on thequantity 4in the dialog box
- Highlight cells B2:B3 in the worksheet to enter this range
- Click Okay to close the dialog package and come back to the worksheet
- The number695should show up in mobile A7 - as this can be the sum of the figures situated in cells A1 to M3
- When you click on cell A7 the total function=Amount(A1;A3;A6;C2:B3)shows up in the input range above the worksheet.