In prior versions of Excel, I could highlight cell ranges and it
automatically displayed the total of them at the bottom. This incredibly
valuable feature was removed and I cannot understand why on earth it was.
This is extremely frustrating - do the product designers even talk to people
who use these products? I am a CPA/CMA/MBA and a heavy user of Excel and
find these baffling.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

You didn't say which version of XL you're using. I don't know if they took
it out in subsequent versions (after XL 2000), however, try right clicking in
the area where the Sum appears and see if a menu comes up. If so, there is
an option to activate the sum feature.


"Tieornot" wrote:

In prior versions of Excel, I could highlight cell ranges and it
automatically displayed the total of them at the bottom. This incredibly
valuable feature was removed and I cannot understand why on earth it was.
This is extremely frustrating - do the product designers even talk to people
who use these products? I am a CPA/CMA/MBA and a heavy user of Excel and
find these baffling.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I use 2003 and it is still available. Like JMB said, right click in the
bottom right-hand corner of the Excel window where you would normally see the
sum of highlighted cells and select SUM (or average, or count, etc)
--
JNW


"JMB" wrote:

You didn't say which version of XL you're using. I don't know if they took
it out in subsequent versions (after XL 2000), however, try right clicking in
the area where the Sum appears and see if a menu comes up. If so, there is
an option to activate the sum feature.


"Tieornot" wrote:

In prior versions of Excel, I could highlight cell ranges and it
automatically displayed the total of them at the bottom. This incredibly
valuable feature was removed and I cannot understand why on earth it was.
This is extremely frustrating - do the product designers even talk to people
who use these products? I am a CPA/CMA/MBA and a heavy user of Excel and
find these baffling.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions