Use AutoSum to enter a formula in the selected cell to calculate the total of all the contiguous cells above.

Step 1: Locate the Selected Cell

Identify the cell where you want to display the total sum of all contiguous cells above it.

Step 2: Access the AutoSum Feature

Click on the “Formulas” tab in the Excel ribbon, or alternatively, you can find the AutoSum button on the “Home” tab.

Step 3: Applying AutoSum

1. With the desired cell selected, click the AutoSum button (Σ symbol). Excel will automatically create a sum formula and highlight the contiguous cells above.
2. Ensure that the highlighted range includes all the cells you want to calculate the total for.

Step 4: Confirm the Formula

Press the “Enter” key. Excel will compute the total of the highlighted cells and enter the result in the selected cell.

Final Answer

The AutoSum feature will display the total of all selected contiguous cells above the chosen cell. The formula typically appears as =SUM(A1:A5) assuming the cells A1 to A5 contain the values you want to add.