In previous versions and Excel 2003 you could highlight a row or column of
numbers and the total of that group of cells would appear in the lower right
of the Excel screen. I've noticed recently that this no longer happens which
suggest that I've inadvertently turned something off. How do I get the total
of a selected row or column to be automatically caluclated and shown. I know
how to do the @sum thing but this is different. What I'm looking for is an
Excel feature that I've seemingly managed to turn off.

abmonty

Right click in the area where the sum, aka "total", used to be. Make sure
"sum" is checked.

Does this help?

Mike Rogers

"abmonty" wrote:

In previous versions and Excel 2003 you could highlight a row or column of
numbers and the total of that group of cells would appear in the lower right
of the Excel screen. I've noticed recently that this no longer happens which
suggest that I've inadvertently turned something off. How do I get the total
of a selected row or column to be automatically caluclated and shown. I know
how to do the @sum thing but this is different. What I'm looking for is an
Excel feature that I've seemingly managed to turn off.

That "feature" is displayed in the Status Bar, so you could have *either*
disabled the Status Bar ... <View <Status Bar
OR
If the Status Bar is present, then right click in that area of the bar, and
check the particular action you're interested in.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"abmonty" wrote in message
...
In previous versions and Excel 2003 you could highlight a row or column of
numbers and the total of that group of cells would appear in the lower right
of the Excel screen. I've noticed recently that this no longer happens
which
suggest that I've inadvertently turned something off. How do I get the
total
of a selected row or column to be automatically caluclated and shown. I
know
how to do the @sum thing but this is different. What I'm looking for is an
Excel feature that I've seemingly managed to turn off.

Additionally you will not get a sum (or any other aggregation) if any of the
formulas in the selected range results in an error such as #Ref, #N/A or...
--
HTH...

Jim Thomlinson


"Mike Rogers" wrote:

abmonty

Right click in the area where the sum, aka "total", used to be. Make sure
"sum" is checked.

Does this help?

Mike Rogers

"abmonty" wrote:

In previous versions and Excel 2003 you could highlight a row or column of
numbers and the total of that group of cells would appear in the lower right
of the Excel screen. I've noticed recently that this no longer happens which
suggest that I've inadvertently turned something off. How do I get the total
of a selected row or column to be automatically caluclated and shown. I know
how to do the @sum thing but this is different. What I'm looking for is an
Excel feature that I've seemingly managed to turn off.

Right-click on the Status bar and select the display you wish.

Sounds like you are currently set to "none"


Gord Dibben MS Excel MVP

On Fri, 1 Dec 2006 08:06:00 -0800, abmonty
wrote:

In previous versions and Excel 2003 you could highlight a row or column of
numbers and the total of that group of cells would appear in the lower right
of the Excel screen. I've noticed recently that this no longer happens which
suggest that I've inadvertently turned something off. How do I get the total
of a selected row or column to be automatically caluclated and shown. I know
how to do the @sum thing but this is different. What I'm looking for is an
Excel feature that I've seemingly managed to turn off.