Worksheet autocalc with min function in error

L

Loretta

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

Niek Otten

Hi Loretta,

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

--
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.
| --
| Thanks!
| Loretta
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum after Filter, Count after Fliter 2
Using MIN Function on cells containing formulas 2
Using SUM function to count hours BUT ignore Letters? 6
Is there a way to use labels and 3-D references in a formala? 2
Min Function Excluding Zero Values & More 8
Adding numbers in rows results in zero. help! 4
MIN date from multiple different worksheets in a workbook 4
SUM function across multiple worksheets within one workbook 4

Top