ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   auto sum not working - how enable? (https://www.excelbanter.com/excel-discussion-misc-queries/210968-auto-sum-not-working-how-enable.html)

ALOTT5K

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!

ALOTT5K

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!


Loris

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