auto sum in lower right corner does not appear when I highlight ce

  • Thread starter frustrated financial person
  • Start date
F

frustrated financial person

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?
 
G

gjcase

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
 
K

Karly Wai

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?
 
D

Dave Peterson

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.
 
B

Brian

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?
 
G

Gord Dibben

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
 
H

hockman44

A bit late, but I had the same problem until I maximized the window for
Excel. When it is set to other than maximum, the "Ready bar" does not appear.
 
Top