Excel Addition Formula Definition:
Excel Addition Formula uses to add the values. It adds values in a column, individual cells etc. We can add values in excel without using any formula with “+” symbol as well.
Formula: =SUM(number1, [number2], [number3]……)
Explanation with Example Questions:
After teaching the concept of AND Function to her children, Brenda decides to teach the use of the SUM formula in Excel. So, she gave some questions to both her children to teach the concept.
- Find the sum of column1 and column2 without using the formula.
- Find the sum of column1 and column2 by using the SUM formula.
- Find the sum of column1 and column2 by using the SUBTOTAL formula.
Now coming to the answers:
Sum of Column1 and Column2 without using formula
Formula: =E6+F6
Here “+” adds the values in two different cells,i.e., E6 and F6. To apply the formula in the whole column, drag down from the bottom right of the G6 cell to the G12 cell.
Answer: 35
Sum of Column1 and Column2 using SUM formula
Formula: =SUM(E6,F6)
Excel Addition Formula or Excel SUM Function adds values in cells E6 and F6. To apply the formula in the whole column, drag down from the bottom right of the G6 cell to the G12 cell.
Answer: 35
Sum of Column1 and Column2 using SUBTOTAL formula
The SUBTOTAL function returns a subtotal of values in the given ranges. This function can perform addition, average, multiplication etc.
General Formula: =SUBTOTAL(function_num, ref1, [ref2], …)
For Addition, function_num is either 9(include hidden rows) or 109(neglect hidden rows). We are using 9 in our solution.
Formula: =SUBTOTAL(9,E6,F6)
The SUBTOTAL function adds values in cells E6 and F6. To apply the formula in the whole column, drag down from the bottom right of the G6 cell to the G12 cell.
Answer: 35
After learning a lot of Excel concepts, Carl and Carly are finally gaining some confidence and are trying to help Brenda in home budgeting.