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.
Sommaire
Presentation
To perform a SUM function in Excel
- You simply start with the = sign in your cell
- Then, you enter the word SUM
=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 SUM 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
The function Sum has its own shortcut. It's the only function in Excel with a shortcut
 +  |
Insert the function SUM in your active cell |
Related articles
Have a look at these other articles that could help you in your work
