How to do Addition in Excel - Bangalore

When you're working with numbers in Excel, you'll almost certainly need to compute the total.Excel can help you figure out the overall cost of an item or count up your store's monthly sales fast and efficiently.With step-by-step instructions, this article shows you how to accomplish addition in Excel. Simply follow along as we take you through some basic Excel addition assignments.

1.Simple addition using formula



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.