Forum Discussion

Alan Taylor's avatar
Alan Taylor
Copper Contributor
Oct 08, 2018

autosum not updating result

If I complete a collumn of 12 cells each with a value of 10 and put an autosum into the box beneath I get the result 120. If I change one of the cell values in the column of 12 cells the total does n...
Excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 08, 2018

    Hi Alan,

     

    Please check in ribbon Formulas tab if Calculation options are set on Automatic

Richard Quan's avatar
Richard Quan
Icon for Microsoft rankMicrosoft
Oct 08, 2018

On ribbon File->Options->Formulas and check your calculation is automatic

  • Alan Taylor's avatar
    Alan Taylor
    Copper Contributor
    Oct 08, 2018

    Thanks Richard.

    Problem sorted

     

    Alan

Resources