Get highlighted numbers to SUM instead of NUM @bottom of screen?
 

When you highlight a column of numbers the bottome of the screen shows the
number of cells highlighted. How do I change it to show the SUM of the
highlighted cells?

Hi

You need to right-click on that number and a list of otions will appear,
including SUM, AVERAGE etc.

Andy.

"jimbo" wrote in message
...
When you highlight a column of numbers the bottome of the screen shows the
number of cells highlighted. How do I change it to show the SUM of the
highlighted cells?

Right-click it and choose SUM instead of COUNT.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jimbo" wrote in message
...
When you highlight a column of numbers the bottome of the screen shows the
number of cells highlighted. How do I change it to show the SUM of the
highlighted cells?