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