Forum Discussion

katetraicos's avatar
katetraicos
Copper Contributor
Mar 05, 2018

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

  • katetraicos's avatar
    katetraicos
    Copper Contributor
    Yes, just checked that too. it is automatic. I really dont know why this wont work
    • Jamil's avatar
      Jamil
      Bronze Contributor

      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.

  • Jamil's avatar
    Jamil
    Bronze Contributor
    Just check under Formula Tab and make sure that calculation option is automatic. if it is manual. it will not work.