auto sum not working - how enable?
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! |
auto sum not working - how enable?-IGNORE-answer: chg max to 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! |
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! |
All times are GMT +1. The time now is 08:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com