How to do Addition in Excel
Feb 7, 2022 04:11:07 AM
1Y, 1st floor, 100Ft Ring Road, 6th Main Road 7th Block, 4th Phas,
Bangalore, Karnataka,
India 1
08072722287
Using a formula to make a simple addition
Using the method, you can quickly add the integers from B2 to B6:
=B2+B3+B4+B5+B6
The identical formula is typed into another cell, as shown in the example.
Example-2 is a simple addition formula.
2.Addition using the SUM function
When there are less numbers/cells to add, the prior technique works effectively. However, if you have a huge set, it will be impossible to do it manually.
Let's look at how to add in Excel with the SUM function.
The SUM() method provides a faster way to add the values of many cells together.
Individual cells can be added up by simply identifying the start and last cell in a range of cells you want to total up.
The SUM function's key advantage is that it can be used to create simple formulas that add up hundreds or thousands of cells all at once.
SUMMARIZATION (Range)
To see how the SUM() method works, take the previous example.
We fill out the form.