Forum Discussion

Timi_Hysaj's avatar
Timi_Hysaj
Copper Contributor
May 28, 2023
Solved

Formulas and function not working

Dear Sir Madame    I am having issues with Autosum option in one of the files, I most have messed up a formula in one of the numbers and I am getting this at the end   =SUM(E6:E765)
  • HansVogelaar's avatar
    HansVogelaar
    May 28, 2023

    Timi_Hysaj 

    The SUM formula in B436 is

     

    =SUM(352:445)

     

    This formula sums all rows from 352 to 445. This includes B436 itself, so it is a circular reference.

    I don't know what you intended here - do you really want to sum entire rows? Or should it be =SUM(B352:B435) ?

     

    The formula in B716 is

     

    =SUM(B704:B716)

     

    This includes B716, so it is also a circular reference. Change it to =SUM(B704:715)

Resources