Microsoft Office

How To Use Autosum In Microsoft Excel

To use AutoSum in Microsoft Excel, select the empty cell below a column of numbers or to the right of a row, choose AutoSum on the Home tab, check the highlighted range, and press Enter. Excel inserts a SUM formula. If the suggested range misses.

Which licences fit your PC setup?

Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.



Add a column or row with AutoSum

AutoSum creates a formula for you; SUM is the function that performs the addition. The important check is whether that formula includes exactly the cells you intend to total.

  1. Select an empty cell immediately below your column of numbers. For a row, select the empty cell immediately to its right.
  2. On the Home tab, choose AutoSum in the Editing group. You can also find AutoSum on the Formulas tab.
  3. Check the range Excel highlights. If necessary, drag across the correct cells or edit the cell references in the formula.
  4. Press Enter to display the total. Select the result cell to inspect the formula in the formula bar.

For example, if your values occupy B2:B6, the total in B7 should use =SUM(B2:B6). The colon means that every cell from B2 through B6 is included. For values across B2:F2, place the total in G2 and check that the formula reads =SUM(B2:F2).

Microsoft's AutoSum instructions illustrate the same process for columns and rows.

Use the keyboard shortcut or check a quick total

In Excel for Windows, select the result cell and press Alt + = to insert AutoSum. Check the proposed range, then press Enter. This shortcut inserts a sum, rather than an average or count.

If you only need to inspect a total, select the numeric cells and look for Sum on the status bar at the bottom of the window. This does not insert a formula into your worksheet. Microsoft's guide to SUM and the status bar explains these options.

Choose Average, Count Numbers, Max or Min

Use the arrow beside AutoSum to choose a different calculation. Clicking the main AutoSum button alone does not switch functions.

  1. Select an empty cell for the result.
  2. Open the AutoSum drop-down menu and choose the calculation you need.
  3. Check or replace the suggested range, then press Enter.
  • Average inserts AVERAGE, which calculates the arithmetic mean of the numeric values.
  • Count Numbers inserts COUNT, which counts cells containing numbers.
  • Max inserts MAX, which returns the largest numeric value.
  • Min inserts MIN, which returns the smallest numeric value.

For the range B2:B6, an average formula would be =AVERAGE(B2:B6). A count would be =COUNT(B2:B6). Count Numbers does not count names or other text entries. To count non-empty cells, including text, enter =COUNTA(B2:B6) instead. Microsoft's COUNTA reference explains that distinction.

Total several columns or separate ranges

Add totals to neighbouring columns

If columns B, C and D each contain numbers in rows 2 to 6, select the empty cells B7:D7 and choose AutoSum. Excel can create a separate total for each column. Inspect the formulas to confirm that each covers the intended rows.

You can also copy a total formula across to another column. Relative references adjust with the move: copying =SUM(B2:B6) one column to the right produces =SUM(C2:C6). Check the destination range if the columns have different lengths.

Add non-adjacent ranges with SUM

When your values are in separate blocks, enter the SUM formula directly rather than relying on AutoSum to guess the selection.

  1. Select an empty cell outside the ranges being added.
  2. Enter =SUM(B2:B6,D2:D6) to add both blocks.
  3. Press Enter, then check that neither range contains an existing total that would duplicate your values.

Microsoft's SUM formula guide covers multiple ranges. These examples use commas between arguments; your regional settings may require semicolons.

Calculate totals for filtered data and tables

A SUM formula includes values in filtered-out and manually hidden rows. Applying a filter does not make an existing SUM formula calculate only visible entries. Inspect the formula instead of assuming the displayed total follows the filter.

For a vertical list in B2:B20, enter =SUBTOTAL(109,B2:B20) in a cell outside the list to sum values while excluding filtered-out and manually hidden rows. Use =SUBTOTAL(9,B2:B20) if manually hidden rows should remain included. Both exclude rows removed by a filter, as described in Microsoft's SUBTOTAL reference.

If your data is already an Excel table, its Total Row provides a convenient alternative:

  1. Select a cell inside the table.
  2. On the Table Design tab, enable Total Row.
  3. Select the Total Row cell beneath the column you want to add, open its drop-down menu and choose Sum.

The resulting formula normally uses SUBTOTAL with a table column reference. Microsoft's table totals guide shows how to choose other calculations there too.

Check a total that looks wrong

  • Inspect the range. A blank row or separate block can cause AutoSum to suggest only part of your list.
  • Check numbers stored as text. SUM ignores text within referenced cells, so imported amounts may need converting to numbers.
  • Keep the total outside its own range. Including the result cell creates a circular reference.
  • Check newly added entries. Changing values inside the range updates the result, but values appended outside that range may require a formula change.

For related spreadsheet help, browse the Microsoft Office guides. If an Office setup issue prevents editing, the guides on Office activation using Command Prompt and finding an Office product key using Command Prompt address those separate tasks.

Try AutoSum on one column in your worksheet, then select the result and verify the first and last cell references before using the total.

Other editions for separate workloads

Other editions for separate workloads; prices in AUD, confirm the total on the listing.

How to check this worked

  1. Open Settings, System, Activation and confirm the edition shown.
  2. Enter the key and run activation; expect a green tick within a minute.
  3. Reboot and re-check activation survives the restart.

FAQ

What else should you know before buying?

What do I need before starting?
Read the requirements and confirm the edition first; the steps assume the machine is compatible.
How do I know the licence is genuine?
Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
Is this a subscription?
Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
What if the key fails?
Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.

Check who prepared and reviewed this guide

Written by
MS.Codes editorial
Reviewed by
Support team

Last verified: (source review; see test status above).

Recent Post