Excel Formula

New Contributor

Excel Formula

No matter what I do my AutoSum feature will not work.

I have used it for years but for some reason it just wont work. Using a Mac

Very frustrating...


3 Replies

Re: Excel Formula

Just check under Formula Tab and make sure that calculation option is automatic. if it is manual. it will not work.

RE: Excel Formula

Yes, just checked that too. it is automatic. I really dont know why this wont work

Re: RE: Excel Formula

The next step is to make sure that those cells that you are summing are not formatted as text.


if they are, then sum does not work. so convert them to real numbers and by then the autosum should work.

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
60 Replies
Security Warning: Automatic update of links has been disabled.
Mark Adams in Excel on
6 Replies
Mark 777 in Excel on
47 Replies
Force user to SAVEAS
Man Fai Chan in Excel on
12 Replies
Banded Rows in Excel not working
Emily Ross in Excel on
3 Replies
2 Way Cells
Ryan Dolinar in Excel on
14 Replies