View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Loris Loris is offline
external usenet poster
 
Posts: 39
Default auto sum not working - how enable?

The number that appears on the right side of the status bar when one or more
value cells are selected can be a sum, an average, a max, a min, or a count.
It sounds like yours is set to max. simply right click that portion of the
status bar and a menu will appear from which you can select sum.

"ALOTT5K" wrote:

when select group of cells, in status bar (lower right corner) only displays
largest value in group. how do you enable auto sum or fix this problem?

thanks for help!