How to Add Numbers in Excel (2 Easy Ways)

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)

Table of Contents hide

Download Practice Workbook

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

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

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.]

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.

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

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