AutoCalculate appears disabled - how enable??

[ALOTT5K]

My autocalculate on my worksheets do not work for cells in a column, row or
group of cells selected. it only displays the greatest value in the group of
cells.

How do I enable the autocalculate or fix this problem on my worksheets?

Thank you for your help!

 

[Jim Thomlinson]

Tools -> Options -> Calculations (tab) -> Auto Calculate

 

[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.