Forum Discussion

DON CULP's avatar
DON CULP
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...
Macros & VBA
Need Help
SergeiBaklan's avatar
SergeiBaklan
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's avatar
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's avatar
    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's avatar
      Rgleghorn
      Copper Contributor
      Jun 27, 2021
      correction: the SUM function is displaying the SUM formula. Thank you.

Resources