auto sum not working - how enable?

A

ALOTT5K

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!
 
A

ALOTT5K

ALOTT5K said:
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!
 
L

Loris

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.
 

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

Top