Status Bar Sum Box

[Guest]

Any idea why the sum box disappeared from my status bar in XL2000? Or how to
get it back? I have autocalculate on.

 

[Paul B]

Phil, try tools, options, view, and see if status bar is checked

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Ragdyer]

And, if the "Status" bar *is* checked, and visible, try right clicking in it
(status bar)and click on one of the functions that are displayed.
You'll probably find that "None" is checked.

 

[Guest]

The status bar appears to be divided into a segment for page tabs on the left
and a segment for scrolling left to right on the right side. I have tried
right clicking all along the bar, but only get the drop down scrolling menu.
As I move the cursor along the status line I get no arrows to move the edges
of the segments.

Thanks

 

[David McRitchie]

Hi Phil,
You are looking at the "sheet tabs" which FWIW isn't even turned on or off
in View toolbars, but it is in Tools, Options, View..

You were referred to the statusbar, take a look at
http://www.mvps.org/dmcritchie/excel/statusbar.htm

 

[Guest]

When I took the check off of "show sheet tabs" the status bar changed to just
the scrolling segment across the bottom of the sheet. Still no sum box.

Thanks

 

[David McRitchie]

Sorry for misleading you with an aside remark, turn the show sheet tabs back on, and then
read the web page I pointed to.

 

[Guest]

No problem.

I read the web page you pointed to but saw no reference to how you get the
sum segment of the status bar back once it has disappeared.

What am I missing?

Thanks

 

[David McRitchie]

Hi Phil,
I don't know what to say other than to repeat/reword material that is already
on that page. http://www.mvps.org/dmcritchie/excel/statusbar.htm

You must have more than one cell selected and at least one of them
must have a number in order to see a SUM appear in the box.

Right click anywhere on the status bar to make sure you have
SUM checked.

Does =SUM(a:a) or whatever show the sum you are looking for.
Check one of the cells with a number to verify it has a number
=ISNUMBER(A4) should show TRUE for a number

If what should be a number is text instead, then try the TRIMALL
macro at http://www.mvps.org/dmcritchie/excel/join.htm#trimall
and additional explanations and things to try at
http://www.mvps.org/dmcritchie/excel/join.htm#debugformat

 

[Gord Dibben]

Phil

You have the Status Bar turned off.

View>Status Bar. Click the button.

Gord Dibben Excel MVP