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

**The SUM function**You can write the name of the function and select your data

**The****∑**symbol in the ribbonBy clicking on this symbol, you will perform the sum of your data

**The Shortcut Alt + =**There is only one function in Excel that can created with a shortcut

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

- Start with the
**=**sign in your cell - Then, you enter the word
**SUM** - Then you open a parenthesis.
- Select all the cells that you want to include in your sum
- 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 + =**

- Select your data to add
- Press Alt + =

## #4: The Quick Analysis

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

- Select your Data
- Click on the Quick Analysis icon
- Go to the menu
**Totals** - 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

- The most useful Statistics Excel functions
- Understand the Standard Deviation
- Calculate Percentage Increase with Excel
- Running Total in Excel

angus

15/02/2022 @ 00:28

cool 🙂

Colette N Martin

17/09/2019 @ 06:03

Loke the easy to follow instructions

Frédéric LE GUEN

26/11/2019 @ 15:25

Sarah

19/11/2018 @ 12:35

Very easy to understand, thank you.

Mithu Roy

26/06/2018 @ 09:39

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