Excel 2003 sum figures without formula

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

Guest

In previous versions of excel you could sum figures without a formula and see
the running tally in the bottom right of the screen. For example:

Column A Column B Column C
20 30 10
25 15 5
12 45 50

If I would select (aka highlight) 20, 15, 12; I would see a running tally of
47. But on my version of 2003 I no longer have that function.

Could someone please tell me how to get that function back? I hate to keep
creating formula for something so basic.
 
It should just be that your view is not enabled. Go to View on the main
toolbar and "check" Status Bar
 
Also, if you do have "Status Bar" selected, try right-clicking on the bar.
You might have to try it in a couple of different spots along the bar, but
eventually you should get a context-sensitive menu with various options
(Average, Count, Sum, etc.). Check next to "Sum" and you should be good to go.
 

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

Similar Threads

How can make a formula to add add the nominators and denominators 1
Summing multi-level bill of material 6
Excel Getting an annualized figure based on YTD in Excel 1
Summing multiple account #s in one cell, by referencing 4
Request for formula 10
sum product if 2
sum results based on a reference 4
sumif with a lookup formula 5

Back
Top