How to Add Numbers in Excel (2 Easy Ways)

Quick View to Add Numbers in Excel

While working in Excel, we often are to add numbers for various purposes. Today I will be showing how to add numbers in Excel.


How to Add Numbers in Excel (Quick View)

Quick View to Add Numbers in Excel


Download Practice Workbook


How to Add Numbers in Excel

Here we’ve got a data set with the Month names and Sales of a company called Sunflower Group.

Data Set to Add Numbers in Excel

Our objective today is to add the sales of all the months to find out the total sales of the year.


1. Using the SUM Function

You can use the SUM function of Excel to add numbers in Excel. The syntax of the function is:

=SUM(number1,number2,...)

To add numbers in a range of cells, you can use:

=SUM(range)

Therefore, to add the total sales of all the months, the formula will be:

=SUM(C4:C15)

[Here C4:C15 is the range of my data (Sales). You use your one.]

Quick View to Add Numbers in Excel


2. Using Autosum Tool from Excel Toolbar

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

  • To add numbers in a column, select the immediate cell below the numbers and go to Home>Autosum tool in Excel Toolbar under the Editing section.

Autosum Tool to Add Numbers in Excel

  • Click on AutoSum. It will generate the SUM function for you.

SUM Function Generated by Autosum Tool

  • Similarly, to add numbers in a row, click the immediate cell left to the numbers and go to Home>AutoSum tool in Excel Toolbar.

Autosum Tool to Add Numbers in Excel

  • Then click AutoSum. It will generate the SUM function for you.

SUM Function Generated by Autosum Tool in Excel


Conclusion

Using these methods, you can add numbers in Excel. Do you have any questions? Feel free to ask us.

Rifat Hassan

Hello! Welcome to my profile. Here I will be posting articles related to Microsoft Excel. I am a passionate Electrical Engineer holding a Bachelor’s degree in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology. Besides academic studies, I always love to keep pace with the revolution in technology that the world is rushing towards day by day. I am diligent, career-oriented, and ready to cherish knowledge throughout my life.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo