Question

Write down the steps to find out the total of a range of cells using AutoSum

Answer 1

To use AutoSum in Excel, just follow these 3 easy steps:

Select a cell next to the numbers you want to sum:

To sum a column, select the cell immediately below the last value in the column.

To sum a row, select the cell to the right of the last number in the row.



Click the AutoSum button on either the Home or Formulas tab.

A Sum formula appears in the selected cell, and a range of cells you're adding gets highlighted (B2:B6 in this example):



In most cases, Excel selects the correct range to total. In a rare case when a wrong range is selected, you can correct it manually by typing the desired range in the formula or by dragging the cursor through the cells you want to sum.