The lower right corner of my screen used to show the total of the cells that
I highlighted on my spreadsheet. Now that no longer appears. How do I get
it back?

Right-click the bar in the lower rh corner where the sum used to appear
(actually you can click anywhere to the right of the "Ready"). Select
SUM from the drp-down list. Note you have several other options to
choose from.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=512840

I had the same problem as the frustrated financial person but the ready bar
has disappeared on my excel sheet as well. I cant seem to raise it using the
arrow. What can I do to get auto sum back?


"gjcase" wrote:


Right-click the bar in the lower rh corner where the sum used to appear
(actually you can click anywhere to the right of the "Ready"). Select
SUM from the drp-down list. Note you have several other options to
choose from.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=512840

Make sure that the statusbar is visible
tools|Options|view tab|check statusbar

And then select at least two cells with numbers in them.

Do you see the sum?

If you see some other function, then rightclick on that statusbar and choose
Sum.

Karly Wai wrote:

I had the same problem as the frustrated financial person but the ready bar
has disappeared on my excel sheet as well. I cant seem to raise it using the
arrow. What can I do to get auto sum back?

"gjcase" wrote:


Right-click the bar in the lower rh corner where the sum used to appear
(actually you can click anywhere to the right of the "Ready"). Select
SUM from the drp-down list. Note you have several other options to
choose from.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=512840



--

Dave Peterson

Is there a way to make the sum number on the status bar bigger or is there a
function that will give the sum of highlighted cells in another cell?

You cannot make the sum number on the status bar larger without changing
your display appearance or theme in Windows settings.

Try either of these macros to sum the selection.

Sub Sum_Range()
Set rng = Selection
Set rng1 = rng.Offset(rng.Rows.Count, 0).Resize(1, 1)
rng1.Formula = "=Sum(" & rng.Address & ")"
End Sub

Sub Sum_Range22()
Set rng = Selection
MsgBox WorksheetFunction.Sum(rng)
End Sub


Gord Dibben MS Excel MVP

On Mon, 13 Oct 2008 07:18:01 -0700, Brian
wrote:

Is there a way to make the sum number on the status bar bigger or is there a
function that will give the sum of highlighted cells in another cell?