Forum Discussion

Copper Contributor

Jul 18, 2018

Solved

Sums & Totals no longer calculating

I have set up spread sheets to keep track of job totals and independent contractor pay. These are simple "SUM" and "MULTIPLY" functions. Up until about 2 weeks ago, I would enter numbers and totals...

SergeiBaklan
Jul 18, 2018
Hi Don,

Please check in ribbon Formulas tab->Calculation Options in drop down menu if it set on Automatic.

Or File->Options-Formulas and here select Automatic

Diamond Contributor

Jul 18, 2018

Hi Don,

Please check in ribbon Formulas tab->Calculation Options in drop down menu if it set on Automatic.

Or File->Options-Formulas and here select Automatic

Darlene Silberman
Copper Contributor
Aug 09, 2018
I have checked the settings yet when I try to sum the only thing I get is the "sum formula".
Even if I try to type @sum(#:#) it just doesnt work.
Darlene

SergeiBaklan wrote:
Hi Don,

Please check in ribbon Formulas tab->Calculation Options in drop down menu if it set on Automatic.
Or File->Options-Formulas and here select Automatic
- Rgleghorn
  Copper Contributor
  Jun 27, 2021
  
  I am having the same issue with the SUM function not calculating, but displaying the SUM function. I have verified that my Calculation Options is set to Automatic. What can be the issue?
  
  Thank you,
  Roxane
  - Rgleghorn
    Copper Contributor
    Jun 27, 2021
    correction: the SUM function is displaying the SUM formula. Thank you.
DON CULP
Copper Contributor
Jul 18, 2018
I followed your instructions and it was set to Manual. Clicked Automatic and they started working again. Thank you very much. I would have never known where to look for that.
Have a great day!!!
- MS Roberts
  Copper Contributor
  Sep 16, 2018
  Thanks, it worked for me too.
  - Heather Doyle
    Copper Contributor
    Oct 03, 2018
    Thanks, Me too! No idea how this would have gotten changed in the first place.
- SergeiBaklan
  Diamond Contributor
  Jul 18, 2018
  You too!

Resources