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!

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

Jim Thomlinson


"ALOTT5K" wrote:

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

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:

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