Listing Details:

Assume you wish to add the test scores of a student, as illustrated in the example below.



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.