# How to Add Numbers in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working in Excel, we often need to add numbers for various purposes. After creating a data set, you may feel to edit or add numbers within the existing range. Fortunately, this is really easy to achieve with the help of Microsoft Excel. Today I will show you how to add numbers in Excel.

## 5 Easy Ways to Add Numbers in Excel

This article will demonstrate how to add numbers in Excel by using the SUM function, applying the AutoSum feature, using the keyboard shortcut, and applying the Paste Special command. Here, we will show 5 ways with different criteria to add numbers in Excel. So, to know all the methods properly, you can follow the article accordingly.

### Method 1: Using Keyboard Shortcut to Add Numbers in Excel

Our objective today is to add the sales of all the months to find out the yearâ€™s total sales value by using the keyboard shortcut.

Steps:

• Here weâ€™ve got a data set with the Month names and Sales of a company.
• Firstly, select the C18 cell.
• Then, hold on to the ALT + = sign.

• After that, you will see the following sum formula in the C18 cell.
`=SUM(C5:C17)`

• Therefore, hit Enter.
• Finally, you will get the total sales value.

### Method 2: Applying SUM Function to Add Numbers in Excel

You can use the SUM function in Excel to add numbers. In this section, we will show you how to add numbers by using the SUM function in a range of cells.

Steps:

• Firstly, select the C18 cell.
• Secondly, write down the following formula to add the total sales for all the months.
`=SUM(C5:C16)`

• Thirdly, press Enter.
• Lastly, you will get the total sales value.

### Method 3: Utilizing AutoSum Feature to Add Numbers in Excel Row

You can use the AutoSum feature from the Excel Toolbar to add numbers in a column or a row.

Steps:

• Firstly, To add numbers in a row, select the immediate cell below the numbers and go to Home > AutoSum tool in Excel Toolbar under the Editing section.
• Then, click on AutoSum.
• Finally, click on the Sum function.

• After that, you will see the following sum formula in the G5 cell.
`=SUM(C5:F5)`
• Then, press Enter.

• So, you will get the total for the 5th row.
• Besides, use the Fill Handle tool and drag it down from the G5 cell to the G16 cell.

• As a result, you will see the final output in the below image.

### Method 4: Utilizing AutoSum Feature to Add Numbers in Excel Column

Here, we will show how to add numbers in a column by using the AutoSum feature from the Excel toolbar.

Steps:

• Similarly, to add numbers in a row, click the C5 cell left to the numbers and go to Home > AutoSum tool in Excel Toolbar as we have described in Method 3.
• Then, It will generate the SUM function for you.
`=SUM(C5:C17)`
• After that, press Enter.

• So, you will get the total for the C column.
• Next, use the Fill Handle tool and drag it down from the C5 cell to the C17 cell.

• Finally, you will get the output in the below image.

### Method 5: Applying Paste Special Command to Add Numbers in an Existing Cell Value

The most popular way to add a number to an existing cell value in Excel is with this method. It is also among the methods that save the most time. The procedures are listed below. The same example is used here as well; we want to increase the sales value by \$200.

Steps:

• We must begin by writing 200 someplace on the page. In this instance, we have written in cell E5.
• After that, we need to press Ctrl + C to this value and select from C5 to C16 where we want to add the number.
• Then we will select Paste Special from the paste options in the Home tab in the Ribbon.

• Therefore, a dialog box will appear named Paste Special. We will select Add and then press Enter.

• Finally, we can see that all of the sales figures have been changed and raised by \$200.

You may download the following Excel workbook for better understanding and practice it by yourself.

## Conclusion

In this article, weâ€™ve covered 5 Easy Ways to Add Numbers in Excel. We sincerely hope you enjoyed and learned a lot from this article.Â If you have any questions, comments, or recommendations, kindly leave them in the comment section below.

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rifat Hassan

Rifat Hassan, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, has worked with the ExcelDemy project for almost 2 years. Within these 2 years, he has written over 250 articles. He has also conducted a few Boot Camp sessions on effective coding, especially Visual Basic for Applications (VBA). Currently, he is working as a Software Developer to develop and deploy additional add-ins to enhance the customers with a more sophisticated experience with Microsoft Office Suits,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF