Excel should return feature of highlighted cells as totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/com...dg=microsoft.public.excel.worksheet.functions
 
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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top