5 Excel Addition Formula Tricks That Nobody Tells You

by

The addition is one of the basic arithmetic operations in maths. In excel, most of the time, we will add a few cells or adding multiple rows of excel.

In this article, we will see a different method of addition in the excel workbook.

Excel Addition Formula Tricks

Excel Addition Formula for Multiple Cells Temporary

To add multiple cells in an excel sheet temporarily, excel provides an easy way. To add multiple cells or an entire column, first select the cells or the column, then you can see the sum value in the status bar like this (in Bottom).

Excel Addition Formula for Multiple Cells Temporary 5 Excel Addition Formula Tricks That Nobody Tells You

To select the entire column, you need to select the column letter. This method will be very helpful when you want to see the sum value quickly without doing any extra work.

Excel Addition Formula for Multiple Cells Temporary 5 Excel Addition Formula Tricks That Nobody Tells You

Tutorial for Adding Multiple Cells in Excel

Using Formula adding multiple rows in excel [Sum Function]

Syntax SUM(number1, number2 …)

Using the SUM function, we can add multiple rows from a single column and multiple columns. 

  • First, select where you want the sum result. For example, I selected the cell C1
  • In cell C2 and type equal and sum() (=sum()
  • In the Selected cells between the brackets, select your cells or type
  • To sum A1, A2, A4 then type as =sum(A1,A2,A4)
  • To sum the cells, A1 to A8, then type as =sum(A1:A8)
Excel Addition Formula for Multiple Cells 5 Excel Addition Formula Tricks That Nobody Tells You

In the previous example, we have seen to add multiple rows in excel.

How to add all the numbers in a column in excel

Scenario: Column B has the expenditure of what we spend. Column A has the detail of the expense. Now we want to sum all the spending in column B to know how much we spend.

Daily you will add some values to that sheet. Now, in this case, we can’t use the same method that we used before. Otherwise, we need to change the formula daily by extending the last row value. In the column, D needs to get the total of all expenses.

To handle this scenario, you can use the below formula in cell D1

To sum the entire column, use =sum(B:B)

Now we may wonder the first cell is a text then how the calculation works. Excel is very smart to ignore the text in-between the rows.

Using Formula, adding multiple rows in excel [+ symbol]

In the above method, we used the sum function, but without sum also we can use the + symbol to the addition of two cells or two columns

Adding Two columns

To add two columns, you can use the reference of the two cells and apply the formula to the entire column.

How To Add All The Numbers In A Column In 5 Excel Addition Formula Tricks That Nobody Tells You

Once you complete the formula for the first cell, you can apply the formula to the entire column by dragging or double-click in that cell’s corner.

Read: How to Apply formula to entire columns.

With the + symbol, you can add fewer cells; otherwise, manual work will increase. So, always use the sum function if it’s not column addition.

Awesome Autosum function in Excel

Without Typing Sum, the function to the addition of cells. Yes, Excel has a tab called formula that helps you enter the formula and cells details with one click.

Awesome Autosum function in 5 Excel Addition Formula Tricks That Nobody Tells You

First, select the TAB formula in the ribbon bar. You will see an option like in the above screenshot.       

Now select the cell you want to sum and click the auto sum button or icon.

Using this Auto sum, you can add the cells quickly and get the total value in the last cell.

Excel Addition Auto Sum 5 Excel Addition Formula Tricks That Nobody Tells You

Conclusion

In this article, you can learn the excel addition formula using the SUM function, add a symbol, i.e. + and Auto sum, built-in excel formula. If we missed any excel addition formula tricks, then please share in the comments.

Leave a Comment