Excel Not Showing Sum at Bottom? Fix the Status Bar

Errors & fixes · Updated November 18, 2026

If Excel is not showing a sum at the bottom, select the cells you want to total and make sure Sum is enabled on the status bar: right-click the status bar at the bottom of the Excel window, then select Sum in its menu. If Sum is already checked, the selected range may contain text-formatted numbers or no numeric values for Excel to add.

What the sum at the bottom actually is

The number labeled Sum on Excel’s status bar is a quick calculation for the cells currently selected. It is a display, not a formula entered into a worksheet cell. Select a different range and the displayed result updates to reflect that selection. Clear the selection, and the status bar no longer has that range to summarize.

This distinction matters because a status-bar total is temporary and is not part of the workbook’s data. It will not appear in a printed worksheet, be included in a chart, or be referenced by another formula. If you need a total that remains visible in the sheet, use a worksheet formula or a table Total Row instead.

Excel can also show other quick calculations, such as Average and Count, alongside Sum. These options are independent: a missing Sum does not necessarily mean the other status-bar calculations are disabled, and enabling Sum does not add a total to your worksheet.

Turn on Sum in the status bar

In Excel for Microsoft 365 on Windows, the setting is on the status bar itself, not in the ribbon. Try these steps:

  1. Select one or more cells containing numbers, or select a range that includes them.
  2. Right-click an empty area of the status bar along the bottom edge of the Excel window.
  3. In the menu, click Sum. A check mark indicates that the option is enabled.
  4. Look at the status bar again while the cells remain selected. The Sum value should appear if Excel has numeric values to add.

If you are using Excel on a Mac, Control-click or right-click the status bar to open its customization menu, then enable Sum. A Mac with a trackpad can usually open the context menu with a two-finger click; the exact gesture depends on macOS settings. In Excel for the web, select cells and inspect the bottom status bar; if Sum is not displayed, open its context menu if available and enable the calculation. Available status-bar options can vary by platform and interface updates.

Be sure to right-click the status bar, rather than the worksheet grid or a ribbon tab. Those areas open different menus and will not show the status-bar calculation options.

Check that you selected the right cells

The status-bar result is based on the current selection, so a selection mistake can look like a missing calculation. If you click a single blank cell, for example, there is no numeric value to add. If you select a heading or a range of text, Excel may show a count of entries when Count is enabled, but it has no numbers to sum.

For a contiguous block, drag across the cells or select the first cell and hold Shift while selecting the last one. You can also enter a range in the Name Box to the left of the formula bar, such as B2:B20, and press Enter. Check the highlighted cells before interpreting the status-bar result.

For a noncontiguous selection, hold Ctrl while selecting additional cells on Windows; on a Mac, use Command while selecting. The displayed Sum then combines the selected numeric cells. This is handy for comparing a few separate values, but it is easy to leave out a cell or include an unintended one, so verify the highlights.

Numbers stored as text can be the cause

One of the most common reasons a selected range produces no sum, or a smaller sum than expected, is that some values are stored as text. A cell may look like 25 but not behave like the number 25. This can happen after importing data from a text file, copying values from a web page, entering a leading apostrophe, or using a decimal or thousands separator that does not match the regional settings.

Look for clues such as a green warning indicator in a cell, a leading apostrophe in the formula bar, or numbers aligned differently from neighboring values. These clues are not conclusive by themselves, but they can point to a type mismatch. To convert values, select the affected cells and use the warning menu if Excel offers Convert to Number. For imported data, re-importing with the correct delimiter and locale can be more reliable than trying to repair every cell afterward.

Another quick check is to test one suspicious cell in an unused cell with a formula that adds 0. With the suspected value in A2, enter =A2+0. If Excel returns an error, the value may contain characters or formatting that prevent numeric conversion. Do not use this as a blanket fix without reviewing the data: entries such as product codes, ZIP codes, and IDs may look numeric but should remain text.

Text values in a selection are generally ignored by a sum calculation; numeric values in the same selection can still contribute. Therefore, a displayed total may be nonzero but incomplete rather than absent. Compare the selection with the source data if the result seems too small.

Distinguish the status-bar sum from AutoSum

AutoSum and the status-bar Sum are related only in that both help you see totals. AutoSum inserts a SUM formula into a worksheet cell. The status-bar calculation simply reports the total of the selected numeric cells and does not change the sheet.

For example, with values 12, 8, 15, 5, and 10 in cells B2:B6, the status bar can show 50 when those cells are selected and Sum is enabled. To keep that total in the worksheet, enter =SUM(B2:B6) in another cell. The layout assumed here is the five values in B2:B6; their arithmetic total is 12 + 8 + 15 + 5 + 10 = 50.

In Excel for Microsoft 365 on Windows, select the cell where the total should appear, then choose Home > AutoSum, or use the AutoSum button on the Home or Formulas tab. Excel proposes a range; inspect it before pressing Enter. On Windows, Alt+= is the AutoSum shortcut. On Mac, the shortcut can differ with the keyboard and Excel version, so use the AutoSum button if the shortcut is unavailable. A formula is preferable when the total must be saved, shared, printed, or used in later calculations.

Why a displayed result may not match your expectation

Even when Sum is visible, the value may differ from a total you calculated elsewhere. First check whether every intended cell is selected. Then look for text-formatted numbers, blank cells, and values outside the highlighted range. Excel’s status-bar Sum adds numeric values in the selection; it does not infer that a nearby column or row should be included.

Also consider whether your data includes formulas. A cell containing a formula that returns a number contributes that numeric result to the selected sum. A formula returning text, such as an empty string, is not a numeric amount. If a formula result appears stale, recalculate the workbook: on Windows, press F9 to calculate open workbooks, or check Formulas > Calculation Options and choose Automatic. Calculation settings affect formula results, but they do not turn text entries into numbers.

For filtered lists, be careful about what you mean by total. The status bar is a quick calculation of selected cells, not a purpose-built subtotal that automatically communicates whether filtered-out records are included. For a total designed to respond to filters, use a SUBTOTAL formula or a table’s Total Row and confirm the behavior against your worksheet.

When to use a formula or a table Total Row

Use the status bar for a quick check while reviewing or selecting data. It is especially useful for a fast audit, such as highlighting a column of expenses to see whether the values add to an expected figure. It is not a dependable substitute for a saved total because another user may select a different range, hide the display option, or never notice the number at the bottom.

Use a SUM formula when a total should remain in a particular cell. For a growing dataset formatted as an Excel table, a Total Row can be more convenient: click inside the table, open the Table Design tab, enable Total Row, and choose Sum from the dropdown in the total cell. Table totals adjust with table changes and can be configured for different columns. If filters are involved, inspect the generated calculation and confirm that it matches the intended treatment of hidden rows.

A useful workflow is to use the status bar for a fast visual check, then use a formula or Total Row for any result that belongs in the workbook. The two totals can help verify each other, provided they cover the same cells and use the same rules.

Quick troubleshooting checklist

If the Sum label is still missing or appears unhelpful, work through these checks rather than rebuilding the workbook:

  • Right-click the status bar and confirm that Sum is checked.
  • Select the actual numeric cells, not only a heading, blank cell, or text column.
  • Check whether the values are numbers or numbers stored as text.
  • Review the highlighted range for omitted cells, extra cells, or an accidental selection.
  • If the displayed total seems stale, check calculation settings for formulas in the source cells.
  • If you need a persistent or filter-aware total, use a worksheet formula or Total Row instead.

If none of these resolves it, note whether you are using Excel desktop, Excel for the web, or a Mac version, and whether the issue is that the Sum label is absent or that its number is wrong. Those are different problems: the first is usually a display setting or selection issue, while the second often involves the selected range or the underlying data.

Frequently Asked Questions

Why is Excel showing Count but not Sum?
Count can report how many selected cells contain entries, including text, while Sum needs numeric values to add. Enable Sum in the status-bar menu and check whether the selected values are stored as numbers rather than text.

Can I put the status-bar sum into a cell?
No. The status-bar result is a temporary display and cannot be copied directly as a worksheet calculation. Enter a SUM formula in a cell if you want a saved, reusable total.

Does the status-bar sum update when I change a value?
It generally recalculates for the current selection as cell values change. If the source cells contain formulas and their results do not update, check whether Excel is using Automatic calculation.

Why is my total lower than the numbers I can see?
Some entries may be text, or the selected range may omit cells. Inspect the highlighted range and test suspicious values; text that looks like a number may not be included in the sum.

Is the status-bar sum the same as AutoSum?
No. The status bar displays a quick calculation for selected cells. AutoSum inserts a SUM formula into a worksheet cell, where it can remain in the workbook and be referenced by other formulas.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.