↑ Return to Statistic



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


To perform a SUM function, you simply start with the = sign in your cell and then enter the word SUM.


Then you open a parenthesis. The act of opening a parenthesis will allow you to specify the data to be calculated by the formula.

Double-click directly in the following worksheet in the cell N2 to display the formula and try to finish this exercise.

In the example above, position yourself to cell N2 and begin to write the word form ; then you select cells B2: M2, and finally you close the parenthesis. Automatically, Excel calcul the sum for the cells B2 to M2

= SUM(B2:M2)

Fill each row 3, 4, 5, 6 with the same function SUM to obtain that Excel calcule result on each one.

Using the icon bar

You can also make a sum of a cells with the Σ icon in the Ribbon (tab Home).

Go to the cell in N3 and click on the icon .




Magic! Excel automatically selects the range of cell B3:M3.




It is also possible to reverse the method by first selecting the cells B3:M3 and then you click on the icon Σ. The result will appear in N4.


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




  1. ZQuiet Reviews

    Snoring might seem like a stupid reason to break
    up a relationship but that’s the reality of it. Seeking
    a sleep apnea cure is extremely important to remain in optimal health, as well as to
    avoid a fatal symptom of the condition such as
    a heart attack or stroke. Customer inquiries and orders may also be places through the Email address at

  2. Amelie

    Heya i am for the first time here. I found this board and I find It really useful & it
    helped me out much. I hope to give something back and aid others like you helped me.

Leave a Reply

%d bloggers like this: