AutoSum and Quick Calculations

You now know how to type SUM and AVERAGE by hand. But spreadsheets offer an even faster way for the most common task: AutoSum.

AutoSum is a button that guesses the range you want to total and writes the =SUM(...) formula for you. One click and your column or row is added up.

In this lesson you will learn AutoSum and a few other quick-calculation shortcuts.

In Microsoft Excel, AutoSum lives on the Home tab and again on the Formulas tab. Its icon is the Greek letter sigma, which looks like a stretched E.

Click the cell where you want the total to appear, then click AutoSum. Excel highlights the numbers above or to the left and inserts a SUM formula.

Press Enter to accept it.

The fastest way to AutoSum is the keyboard. Click the empty cell just below a column of numbers, then press:

Alt and = together (on Windows), or Cmd and Shift and T on a Mac.

The spreadsheet instantly writes =SUM(...) with the detected range. Press Enter to confirm.

This shortcut quickly becomes second nature for daily totaling.

AutoSum looks at the cells directly above the active cell. If it finds a column of numbers, it proposes summing them.

If there are no numbers above, it looks to the left for a row of numbers instead.

Its guess is shown as a highlighted range before you confirm. Always glance at the highlight, because the guess is not always exactly what you want.

Sometimes AutoSum grabs too few or too many cells. After you click AutoSum, the suggested range is selected and editable.

Just drag over the correct cells, or type the range you want, before pressing Enter.

For example, if it suggested =SUM(B3:B10) but you also need B2, drag the selection up to include it: =SUM(B2:B10).

AutoSum can fill several totals in one move. Select the empty row beneath a block of data, spanning all the columns you want to total.

Then click AutoSum once. The spreadsheet writes a separate SUM under each column at the same time.

This is a huge time-saver for tables with monthly columns or many categories side by side.

Click the small arrow next to the AutoSum button and a menu appears with more quick functions:

• Average for the mean
• Count Numbers for how many numbers
• Max for the largest value
• Min for the smallest value

Each one writes the matching formula for the detected range, so AutoSum is a shortcut for several functions, not only SUM.

Google Sheets has the same feature. After selecting a range of numbers, look at the bottom-right status bar, which already shows the Sum, Average, Min, Max, and Count.

To write a formula, type =SUM( in a cell and Sheets suggests the range with a tooltip. Press Tab or Enter to accept the suggestion.

The result is the same SUM formula you would type yourself.

For a quick peek without writing any formula, just select a range of numbers. Both Excel and Google Sheets show live results along the bottom edge of the window.

You will see the Sum, Average, and Count update instantly as you change your selection.

This is perfect when you only want to glance at a total and do not need it saved in a cell.

You have sales in B2:B8 and want a total in B9. Click B9, press the AutoSum shortcut, and the spreadsheet writes =SUM(B2:B8) with B2:B8 highlighted.

The highlight matches your data, so you press Enter. The total appears in B9 in seconds, no typing required.

If you later add a row at B9 pushing the total down, the formula range adjusts automatically.

AutoSum is great for simple, contiguous columns and rows. But for anything unusual, typing is clearer:

• Totaling separate ranges, like =SUM(A2:A5, C2:C5).
• Mixing ranges and single cells.
• Skipping a row you do not want included.

Use AutoSum for speed on neat data, and type your own SUM when the layout is more complex.

Test your understanding of AutoSum.

You learned to total data with a single click:

• AutoSum (the sigma button) writes =SUM(...) for the detected range.
• The shortcut is Alt and = on Windows.
• Its dropdown also offers Average, Count, Max, and Min.
• Selecting any range shows live totals in the status bar of both Excel and Google Sheets.

You have now mastered SUM, AVERAGE, mixing ranges, and AutoSum. Great work on your first built-in functions.