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 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+=

+ | 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

## 2 comments

Very easy to understand, thank you.

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