Sum Formula/Function and how to use it

      No Comments on Sum Formula/Function and how to use it

This easy to use sum formula/function is extremely popular in Excel. Almost every worksheet will need to add a group of numbers, which can be achieved with the help of the SUM () formula/function.

Adding two or more cells with the SUM formula

  • Select the cell that will display the results.
  • Type the sum formula in the selected cell beginning with an equal sign. Like this: =SUM()

Excel Sum formula

  • Type the numbers/cells you wish to sum and separate them with a comma.

Excel Sum Formula

  • Press Enter to see the results

Adding range of cells

  • Select the cell that will to display the results.
  • Type the SUM formula in the selected cell beginning with an equal sign. Like this: =SUM()

Excel Sum formula

  • Select the cell range

Excel Sum formula

  • Press Enter to see the results

Using the Auto Sum

If you wish to sum a column or row of numbers, Excel has a simple way of doing it with the help of the AutoSum formula/function.

  • Select the cell next to the numbers you wish to sum
  • Click AutoSum on the Home/Formulas tab

Excel Sum formula

  • Press Enter to display results

If you have any questions related to this article, make good use of the comment box below.

 

Leave a Reply

Your email address will not be published. Required fields are marked *