Worksheet autocalc with min function in error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Loretta - 29 May 2008 19:00 GMT

My worksheet has begun autocalculating cells I highlight with the min
function results instead of the normal sum total, in the status bar area. I
don't know how this happend (was on vacation) and now need to fix. Any
suggestions.

Signature

Thanks!
Loretta

Reply to this Message

Reitanos - 29 May 2008 19:20 GMT

Right-click on it

> My worksheet has begun autocalculating cells I highlight with the min
> function results instead of the normal sum total, in the status bar area. I
[quoted text clipped - 3 lines]
> Thanks!
> Loretta

Reply to this Message

Niek Otten - 29 May 2008 19:24 GMT

Hi Loretta,

Right-click near the Min. You should get a list to choose from, one of which is Sum

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| My worksheet has begun autocalculating cells I highlight with the min
| function results instead of the normal sum total, in the status bar area. I
| don't know how this happend (was on vacation) and now need to fix. Any
| suggestions.

Reply to this Message