Function SUM

This is the most commonly formula used and also the simplest to use. We will see in this page, different methods to perform a SUM in Excel.

Presentation of the SUM function

To perform a SUM function in Excel

  • You simply start with the = sign in your cell
  • Then, you enter the word SUM
  • Then you open a parenthesis.

=SUM(

  • Select all the cells that you want to include in your sum

=SUM(A1:A5

  • Don't forget to close the parenthesis

=SUM(A1:A5)

Using the icon bar

Instead of writing the formula directly in the cell, you can use the symbol Sigma in the ribbon (tab Home)

The method is simple. You can either

  • Select the cell to add and then click on the icon
  • Or, select the cells under your range of cells you want to add and then press


Shortcut

You can easily insert the function SUM with the shortcut Alt+=

touche Alt + Alt + = Insert the function SUM in your active cell

Dynamic sum

You can create a dynamic sum by using the INDEX function. This is more for advanced Excel users

Related posts


Permanent link to this article: https://www.excel-exercise.com/function-sum/


2 comments

    • Sarah on 19/11/2018 at 12:35
    • Reply

    Very easy to understand, thank you.

    • Mithu Roy on 26/06/2018 at 09:39
    • Reply

    Thank you sir for your nice & easy Free Excel Exercise online. It's important.

Leave a Reply

Your email address will not be published.