Search This Blog

Wednesday, December 7, 2016

Using The SUM Formula | LibreOffice Calc V5.2



The SUM formula is used when you want to add up two or more numbers together in Excel. It can also be used to add up the numeric content of two or more cells in your worksheet, or to add up the numeric content of a range of cell in your worksheet.





Using The SUM Formula To Add Numbers
 To use the SUM formula to add up numbers, all you need to do is to
  1. Select the cell you want the answer to be displayed.
  2. Type in SUM preceded by the equal to sign, then followed by parenthesis.
    That is =SUM().
  3. In the parenthesis, insert/type in the numbers you want to add up, separated by comma.
    Example: =SUM(10, 5, 5).
  4. And hit the Enter key in your keyboard or Accept button in the formula bar.

Using The SUM Formula To Add Up Multiple Cells
To add up cells using the SUM formula, all you need to do is to
  1. Select the cell you want the answer to be displayed.
  2. Type in SUM preceded by the equal to sign, then followed by parenthesis.
    That is =SUM().
  3. In the parenthesis, type in the cell addresses of the cells you want to add up, but separate each cell address with comma.
    Example: =SUM(A2, B4, C1).
  4. And then hit the Enter key in your keyboard or the Accept button in the formula bar, to display the answer.
 Using The SUM Formula To Add Up Range Of Cells
 To add up a range of cell using the SUM formula, do the following
  1. Select the cell you want the answer to be displayed.
  2. Type in SUM preceded by the equal to sign, then followed by a parenthesis.
    That is =SUM().
  3. In the parenthesis, type in the cell address of the first cell and the last cell in the range and you want to add up, but separate the two cell address with a Column sign.
    Example: =SUM(A1:A3).
  4. Finally, hit the Enter key in your keyboard, or the Accept button in the formula bar, to display the answer.


Also Read:

Team Pinfoltd



SHARE THIS

0 comments:

Search This Blog