Excel.Tips.Net ExcelTips (Menu Interface)

Status Bar Summing No Longer Available

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Status Bar Summing No Longer Available.

Steve notes that he used to be able to highlight a row or column of numbers in Excel and the sum of that row or column would appear on the status bar. All of a sudden the sum has stopped appearing, and Steve wonders how to get it back.

The first thing to check is that the status bar is actually displayed on the screen. If it is not (for instance, you don't see "Ready" at the left side of where the status bar normally appears), then you need to follow these steps:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the View tab is selected. (See Figure 1.)
  3. Figure 1. The View tab of the Options dialog box.

  4. Ensure there is a check mark in the Status Bar check box.
  5. Click on OK.

With the status bar displayed, Excel can show several different statistics about your selection, not just the sum. Right-click the status bar and you should see a Context menu appear that offers choices such as Average, Count, etc. (The options available depend on the version of Excel you are using.) If None is selected, then the status bar doesn't display anything about your selection. If Sum is selected, then you will see the sum that you desire.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (5491) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Status Bar Summing No Longer Available.

Related Tips:

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

Asif    10 Jan 2017, 11:46
The tip given below by Geoff worked for me too.
Thanks Geoff.
Heather    28 Dec 2016, 12:07
I recently updated to Excel 2013. I use dual monitors and often have a spreadsheet on each monitor. Often times I would highlight a range of cells in a sheet on one monitor and enter the sum in the sheet on the other. With the previous version of Office the status bar stayed active when I clicked inside the other worksheet. Now as soon as I click something in the second instance the status bar goes blank in the first one. Is there a way to keep the status bar 'active'?
Thank you,
Razi    03 Aug 2016, 08:42
The tip given below by Geoff worked for me.
Thanks Geoff.
Geoff    28 Jul 2016, 14:26
Found the answer on another site. The Average and Sum functions are not working because the data in the cells is stored as Text rather than Numbers. Highlight the cells you want the information for, then go to the Data Tab, click on Text to Columns and click "Finish". This should solve the issue.
Leslie    06 Jun 2016, 11:15
My version of Excel 2010 doesn't have this screen in the Options section. Now what?
Mohamad    23 May 2016, 06:13
There are no longer totals on my status bar - where can I turn these on? I have tried the Excel help screen but to no avail. Can anyone help?
Pam    19 May 2016, 12:49
For Office365, with the status bar showing, with a right-click to see options, both Sum and Count have a check mark.

However Count shows 3, but Sum does not show. I just checked, the format of the 3 cells is General.

So what am I doing wrong?
Willy Vanhaelen    08 May 2016, 06:03

You must select a range to add, count ...
Otherwise there is nothing to display.
Peter    07 May 2016, 14:16
These instructions do not work. When I right click on the status bar, I can check or uncheck sum, average, and count, but regardless of what I select, it doesn't display anything.

So, what's the secret? How do I REALLY do this?
Lisa     28 Apr 2016, 17:51
There are no longer totals on my status bar - where can I turn these on? I have tried the Excel help screen but to no avail. Can anyone help?
sunil    25 Dec 2015, 06:15
when i enter long values in excel total of there sum show in status bar as 6.657235e+11. I want to see total amount in status bar. how it is possible.
Ross    27 Nov 2015, 01:09
Hi All

I'm having the same issue as Stephen. I have tried Kelly's solution but it doesn't show me my total (sum) of the selected cells.

Any help would be great as just moved from Excel 2010 where I used this feature a lot.


Darcy    02 Oct 2015, 15:26
This was very helpful! Thank you!
Stephen    01 Oct 2015, 14:59
I have two work books open on two separate monitors. I use the calculator to add information needed for the other worksheet but when I transfer to the next sheet the calculation disappears...
I am in Excel 2013.


Kelly     15 Sep 2015, 15:22
Hold the ALT key when you open Excel and it opens in a new instance which allows your calculation to status in the status bar while selecting the cell in your other spreadsheet
Tracey Pederson    14 Sep 2015, 15:50
I have two work books open on two separate monitors. I use the calculator to add information needed for the other worksheet but when I transfer to the next sheet the calculation disappears...
I am in Excel 2013.

Thank you for any insight on how to correct this issue.

Tracey Pederson
Diana    17 Aug 2015, 21:17
Have Excel 2000 and just discovered AutoCalculate feature is missing in status bar. All boxes in Tools - Options - View look just as described below, but right click on status bar only delivers "Scroll here, left edge, right edge, page left, page right, scroll left, scroll right". PS. Ready is missing from bottom left. Any ideas?
1CitizenJane    15 Jun 2015, 09:27
Yes, the status bar IS checked in Options/View. But the total number is NOT visible in lower right! NOW WHAT?!?
1CitizenJane    02 Apr 2015, 19:09
The "sum" function at the bottom right of any excel spreadsheet has saved me HOURS! But suddenly, it disappeared from every single spreadsheet... hmmmm. [Microsoft?? Are you messing w/my stuff again?] Then, it has taken me mega-time over several weeks to find out how to retrieve/turn-on this feature again! Wa-la!! finally entered correct buzz words in google and got your site/this tip! which of course, worked like a charm! THANKS !! My excel 2003 is 'good as new'! Now I can get back to biz..
Michael (Micky) Avidan    23 Jan 2015, 07:14
Try to locate the MINUS sign at the RIGHT side of the negative Figure...
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
Richard James    23 Jan 2015, 04:09
Search came up in Google. The steps were simple and to the point!
I've even got time to leave feedback. If only every website was as direct as this one. You save people hours!
Thanks :)
PS. Bookmarked you also
kee wei kiat    04 Sep 2014, 03:04
hi, my status bar still not exit "ready' at the left side, please advice how to find it back,thanks
mike    20 Apr 2013, 21:56
My status bar does show the SUM, but if it is negative, it doesn't show 'minus' sign.
Any suggestions?

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.