- Excel Tutorial
- Excel Introduction
- Excel Addition(+)
- Excel Subtraction(-)
- Multiplication(*)
- Excel Division(/)
- Excel IF Function
- Excel SUMIF
- Count & CountIF
- Excel IFerror
- Excel Pivot Table
- Move Pivot Tables
- Excel Drop-Down list
- Conditional Formatting
- Excel Hyperlink
- Excel Vlookup
- Excel Hlookup
- Excel Protect Sheet
- Excel Macros
- Excel Insert Images
- Excel Concatenate
- Excel Text To Column
- Remove Duplicates
- Excel Cell Formatting
- Group in Excel
- Excel Comments
- Excel Freeze Panes
- Excel Charts
- Print in Excel
- Excel Transpose
- Reminders in Excel
- Reduce Excel File Size
- Percentage in Excel
- Substitute Function
- RANK Function
- ROUND Function
- Cell References
- Date Function
- Text Functions
- Percentage Calculation
- Text to Columns
- Rounddown in Excel

EXCEL FORMULAS Excel Tutorial Excel Introduction Excel Addition(+) Excel Subtraction(-) Multiplication(*) Excel Division(/) Excel IF Function Excel SUMIF Count & CountIF Excel IFerror Excel Pivot Table Move Pivot Tables Excel Drop-Down list Conditional Formatting Excel Hyperlink Excel Vlookup Excel Hlookup Excel Protect Sheet Excel Macros Excel Insert Images Excel Concatenate Excel Text To Column Remove Duplicates Excel Cell Formatting Group in Excel Excel Comments Excel Freeze Panes Excel Charts Print In Excel Excel Transpose Reminders in Excel Reduce Excel File Size Percentage in Excel Substitute Function RANK Function ROUND Function Cell References Date Function Text Functions Percentage Calculation Text to Columns Rounddown in Excel

Simple Addition | SUM Function | AUTOSUM

Have you ever wondered **how to do addition in excel?** Microsoft Excel serves to be a perfect tool for any type of calculation. This tutorial takes a quick look to perform additions with step-by-step instructions.

Whether you're figuring out the total cost of an item or adding up the monthly sales at your store, Excel can help you do it quickly and easily. Just follow along as we walk you through some simple additional tasks in Excel.

Suppose you want to add the marks a student scored in an exam, as shown in the example below.

You can easily add the numbers from B2 to B6 using the formula:

**=B2+B3+B4+B5+B6**

As seen in the example, you can see the same formula typed into another cell.

Enter all the cell numbers you wish to add, then press enter, and the sum of the numbers is displayed as shown below.

Similarly, you use the formula to add any number of cells and type in the numbers directly to find the total.

The previous method works well when there are fewer numbers/cells to add. Having a large set, however, would make it difficult to do it manually.

Let us see **how to do addition in Excel** using the **SUM** function.

The SUM() function is a more efficient way to total up the values of multiple cells.

The function can add up individual cells simply by naming the first and last cell in a range of cells you wish to total up.

The main advantage of the SUM function is that it can be used to write simple formulae that add up hundreds or thousands of cells at once.

**Format: SUM(Range)**

Let us consider our previous example to see how the SUM() function works.

We type in the formula,

**=SUM(B2:B6)**

Here B2:B6 indicates the range.

And you can see that the result is as same as the previous result.

The SUM() function can add thousands of cells at a time using the same formula.

Say, SUM(B2:B5000)

Alternately, you can add a range of numbers in different cells.

By now, you must have realized how powerful the SUM function is, to sum up, a large number of cells.

If you want to know how to do addition in Excel when you don't remember the formula, there is a method for that.

By using **AUTOSUM**, you can add numbers directly without having to use a formula. It is located on the Home tab in the Editing group.

To use AUTOSUM, select all the numbers to be added as shown below.

Click on Autosum, the selected numbers get added automatically, and the sum will be displayed as shown.

**Note:** Instead of clicking on AUTOSUM, you can also select the cell just below the column of numbers you want to add, then press Alt + = to automatically place the SUM formula in that cell.

Alternately, you can also select the numbers and find the sum at the bottom right corner of the spreadsheet as shown.

That’s it! Hopefully, you found this post helpful. If you want to know more about Microsoft Excel, check out our tutorials.

- How to do Vlookup in Excel?
- How to find Percentage in Excel?
- Group and Un-Group in Excel.
- Multiple Types of Addition in Excel.
- How to use PivotTable in Excel?

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.