Excel Status Bar Not Showing Sum (2 Possible Solutions)

By default, in Excel, when the user selects a range of numbers, the count, sum, and average value of the selection are shown in the status bar on the bottom of the worksheet. But sometimes the sum does not display in the status bar. Let’s examine some causes and fixes.

Excel Status Bar Not Showing Sum


Solution 1 – Customizing Excel Status Bar Options

In most cases, the reason behind the sum not showing in the status bar is that it is disabled in the Status Bar Options, a context menu from which you can quickly enable or disable status bar indicators such as the page number, the zoom slider, and the Spelling and Grammar check.

The solution is to enable it.

STEPS:

  1. Right-click on the status bar at the bottom of the worksheet.
    Here, you will see a list of different options. Some are ticked and others are not.
  2. Tick the options Sum, Average, and Count.
    Excel Status Bar Not Showing Sum

The status bar now displays the sum, average, and count values.

Excel Status Bar Not Showing Sum

Solution 2 – Changing Cell Format to Numbers

If the sum, average, and count all are enabled in the customized status bar, but are still not displayed in the status bar, the cause is likely the formatting of the cells.

Change Cell Format to Numbers

The status bar will not show the sum if the cells are not in a Number format.

The solution is to convert them into a Number format.

You can use the following methods to change cell formats to numbers:

2.1 – Change Format from the Ribbon

STEPS:

  1. Select the cells.
  2. Go to the Home tab.
  3. Open the Format drop-down options and select Number format.
    Change Cell Format to Numbers

As a result, the problem should be solved.

Excel Status Bar Not Showing Sum

2.2 – Remove Apostrophes Before Numbers

In some cases, you will find an apostrophe (‘) in front of the numbers, which is used to convert the number format to text format. The apostrophes will need to be removed individually from these cells.

Change Cell Format to Numbers

The status bar will display the sum and average value after doing so.

Change Cell Format to Numbers

2.3 – Remove Formatting Using Paste Values Option

You can convert numeric values to Excel’s number format using the Paste Values option too.

The feature removes all formatting and returns the raw value. Numeric values become numbers.

STEPS:

  1. Select the cells and press Ctrl + C to copy them.
    Remove Formatting Using Paste Values Option
  2. Right-click on a new cell.
  3. Select Value under Paste Options from the context menu.
    Remove Formatting Using Paste Values Option

    Click on the image to get a detailed view.

Select the cells of the pasted column, and the status bar will display the sum and average values along with count as normal.
Remove Formatting Using Paste Values Option


Download Practice Workbook


Frequently Asked Questions

How do I copy sum from status bar in Excel?

To copy any summary value from the status bar in Excel, simply click on it. Excel will copy the value to the clipboard. You can then paste it into any cell or text space.

Why is my status bar not showing in Excel?

The status bar may not show up because you are in the full-screen mode, focus mode, or the option is simply disabled from your application. You can use VBA and keyboard shortcuts to hide and unhide status bar in Excel.

Does the sum value in the status bar work with non-contiguous cell selections?

Yes, the sum works for non-contiguous cell selection. Provided they are numbers, the selected cells will also show average, count, minimum, and maximum in the status bar.


Related Articles


<< Go Back to Excel Parts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Osman Goni Ridwan
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

2 Comments
  1. Copy paste values worked. Thank you.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo