AutoSum in Excel | Sum formula in Excel

Sum formula in Excel | Autosum in Excel

This tutorial will explain you in detail regarding AutoSum. What is AutoSum? What are the uses of AutoSum? Where do you find AutoSum in excel? What if AutoSum stops working? How to use AutoSum with other options? This tutorial will give you in-depth Knowledge regarding AutoSum.

Autosum क्या है? | Autosum in Excel

AutoSum in Excel is the most powerful feature in Microsoft Excel. It helps to carry out the task at a great speed. When you want to total a particular row or column you use this function. AutoSum in Excel helps to total up various rows and columns in the spreadsheet. Without inserting a formula in the formula bar you can directly total the row or the column by just clicking on AutoSum. For example, if you want to total the values from cell A1 to cell A7 then you just need to select it and click on AutoSum. This feature does not require remember the formula.

MS Excel में Autosum बटन कहाँ है? | Autosum in Excel

You can find AutoSum button at two places in the ribbon.
The first place is in the home tab.
The second place is in the formula tab.
You can also use the AutoSum shortcut from the keyboard by using the Excel shortcut key ALT + =

MS Excel में Autosum का उपयोग कैसे करें? | Autosum in Excel

When we want to add a single cell or wide range of cells you use this feature to add in excel.

When we want to add a column of a cell we use the following steps:

Step 1: Select the cell below the columns you want to add. You can simply click on a particular cell or you can drag your mouse to select the cell you want to add.
Step 2: Then click on AutoSum in the home tab or in the formula tab of Excel. (You can use the Excel shortcut key ALT+=)

When we want to add rows of a cell we use the following steps:

Step 1: Select the cell beside the row you want to add. You can simply click on a particular cell or you can drag your mouse to select the cell you want to add.
Step 2: Then click on AutoSum in the home tab or in the formula tab of Excel. (You can use the Excel shortcut key ALT+=)

When you want to add multiple columns we use the following steps:

Step 1: Suppose we want to add columns from B to column F. You need to select the columns by dragging the mouse through the cell or by pressing shift continuously and the arrow button to select the cell.
Step 2: After you have selected the cell you click on the AutoSum button. This will help you to total all the columns together.

When you want to add multiple rows we use the following steps:

Step 1: Suppose we want to total the rows in a Spreadsheet. You select a particular cell whether you want to total and the row.
Step 2: click on AutoSum and the total of the row will appear to the right of the worksheet.

When we want to add multiple row and column at the same time:

Step 1: Select the rows and the columns you want to add. You click by dragging your mouse or by using keyboard buttons shift and arrow.
Step 2: Click on AutoSum in the ribbon. The total of the column will appear at the bottom of the column and the total of a row will appear on the right side of the sheet.

We must keep in mind that Autosum in Excel will appear down or at the right of the spreadsheet. It will never appear at the top or to the left of the spreadsheet. You must also see that there is no blank column or row when you use Autosum in Excel. The Autosum in Excel will stop if there is an empty cell. But when you manually select the cell and if that selection includes empty cell then it will be ignored.

अन्य functions के साथ Autosum का उपयोग कैसे करें? | Autosum in Excel

Apart from adding cells, AutoSum in Excel carries out other function as well.

AVERAGE: This feature helps to bring out the average for the cell selected. We can get the arithmetic mean for the selected cell by selecting the column.
COUNT NUMBERS: This feature lets you count the number of cells you have selected.
Maximum: This feature helps you to find the maximum value in the selected cells.
Minimum: This feature helps you to find the minimum value in the selected cells.

To carry out this function i.e average, count numbers, largest value, the smallest value we just need to select the cell and click on the drop-down arrow of AutoSum in Excel and carry out the required operation by selecting it. More functions will open the dialogue box for you and you can see other functions as well.

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.