# The SUM function – All Tricks

Last Updated on 12/11/2023

The SUM function is the most common function used in Excel and also the simplest to use. There are many ways to perform a Sum in Excel

1. The SUM function

You can write the name of the function and select your data

2. The symbol in the ribbon

By clicking on this symbol, you will perform the sum of your data

3. The Shortcut Alt + =

There is only one function in Excel that can created with a shortcut

4. The quick analysis

The quick analysis tool gathers many statical calculations, including the sum

## Don't add the cells one by one

When you work with Excel for the very first time, many people start to create their first formula by selecting many cells

=A1+A2+A3+A4+ ...

The calculation will be correct for sure but what a waste of time, especially if you have hundreds of cells to add 😤😱😡 If you have to calculate the sum of many cells in a quick way, it's much better to use the function SUM.

## #1: Write the SUM function in a cell

To perform a SUM function in Excel it's very simple

2. Then, you enter the word SUM
3. Then you open a parenthesis.
4. Select all the cells that you want to include in your sum
5. Close the parenthesis

=SUM(A1:A5)

## #2: The Sigma symbol

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

The method is simple. You can either

• Select the cell to add and then click on the icon
• Or, select the cell just under your values then press

## #3: The Shortcut

You can also create the SUM function with the shortcut Alt + =

2. Press Alt + =

## #4: The Quick Analysis

The last technique you can use it's with the Quick Analysis Tool.

2. Click on the Quick Analysis icon
3. Go to the menu Totals
4. Select the option Sum of the rows or Sum for the columns

## Dynamic sum

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

## Frédéric LE GUEN

1. angus
15/02/2022 @ 00:28

cool 🙂

2. Colette N Martin
17/09/2019 @ 06:03

Loke the easy to follow instructions

• Frédéric LE GUEN
26/11/2019 @ 15:25

3. Sarah
19/11/2018 @ 12:35

Very easy to understand, thank you.

4. Mithu Roy
26/06/2018 @ 09:39

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

# The SUM function – All Tricks

Last Updated on 12/11/2023

The SUM function is the most common function used in Excel and also the simplest to use. There are many ways to perform a Sum in Excel

1. The SUM function

You can write the name of the function and select your data

2. The symbol in the ribbon

By clicking on this symbol, you will perform the sum of your data

3. The Shortcut Alt + =

There is only one function in Excel that can created with a shortcut

4. The quick analysis

The quick analysis tool gathers many statical calculations, including the sum

## Don't add the cells one by one

When you work with Excel for the very first time, many people start to create their first formula by selecting many cells

=A1+A2+A3+A4+ ...

The calculation will be correct for sure but what a waste of time, especially if you have hundreds of cells to add 😤😱😡 If you have to calculate the sum of many cells in a quick way, it's much better to use the function SUM.

## #1: Write the SUM function in a cell

To perform a SUM function in Excel it's very simple

2. Then, you enter the word SUM
3. Then you open a parenthesis.
4. Select all the cells that you want to include in your sum
5. Close the parenthesis

=SUM(A1:A5)

## #2: The Sigma symbol

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

The method is simple. You can either

• Select the cell to add and then click on the icon
• Or, select the cell just under your values then press

## #3: The Shortcut

You can also create the SUM function with the shortcut Alt + =

2. Press Alt + =

## #4: The Quick Analysis

The last technique you can use it's with the Quick Analysis Tool.

2. Click on the Quick Analysis icon
3. Go to the menu Totals
4. Select the option Sum of the rows or Sum for the columns

## Dynamic sum

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

## Related Article

1. angus
15/02/2022 @ 00:28

cool 🙂

2. Colette N Martin
17/09/2019 @ 06:03

Loke the easy to follow instructions

• Frédéric LE GUEN
26/11/2019 @ 15:25

3. Sarah
19/11/2018 @ 12:35

Very easy to understand, thank you.

4. Mithu Roy
26/06/2018 @ 09:39

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