GuidesFitness Gear & Equipment

AutoSum Vs. AutoCalculate

Knoji reviews products and up-and-coming brands we think you'll love. In certain cases, we may receive a commission from brands mentioned in our guides. Learn more.
AutoSum vs. AutoCalculate The article highlights and compares two of the most important features of excel. Autosum and AutoCalculate are two features in the excel worksheet without which computing high volume data is just impossible , so it is very impor

AutoSum vs. AutoCalculate

The article highlights and compares two of the most important features of excel. Autosum and AutoCalculate are two features in the excel worksheet without which computing high volume data is just impossible , so it is very important to understand and use the Autosum and AutoCalculate feature in MS Excel.

AutoSum Feature

One of the most frequently used functions is the Sum() function that calculates the total of a set of numeric values. Thus, a toolbar button has been endowed with to cite the Sum() function. You can use this button to compute the whole of a group of cells without typing the formula in the intended cells.

Autosum

The AutoSum button will total the values above the destination cell or in the row to the left of the destination cell.

The steps to total cell values by using the AutoSum feature are:

• Select the destination cell.

• Hit the AutoSum icon.

The values in the column above the destination cell or the cells to the left of the destination cell are totaled and the result is placed in the cell that you had selected in Step 1.

In case there are numeric values in the column above the selected cell and also in the cells to the left of the selected cell, AutoSum calculates the total of the cells above the destination cell. If you need to calculate the total of the cells to the left of the destination cell, you need to select the cells and then click on the AutoSum button.

AutoSum can also calculate grand totals in case the data contains subtotals.

AutoCalculate

In several cases, you need to view the total, average or the maximum and minimum values of a set of data.

If you do not want to store the result in a cell, you need not use a formula. As you select the range of cells containing numeric values, you can see the sum of the series on the status bar. This feature is known as the AutoCalculate feature of Excel. You can view either the sum, the average, maximum or minimum values of the selected range of data.

The steps to use the AutoCalculate feature are:

• Select the range of cells containing the numeric values.

• Right click on the Status Bar (the horizontal bar at the bottom of the screen).

• Select the calculation to perform on the selected cell.