Forum Discussion

Timi_Hysaj's avatar
Timi_Hysaj
Copper Contributor
May 28, 2023

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)

Formulas and Functions
  • 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)

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 28, 2023

    Timi_Hysaj 

    Can you provide more detailed information?

    If possible, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

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



      £24,640.00 £600.00 £25,240.00











      £640.00

      £1,200.00

      £860.00

      £1,100.00





      £3,800.00 £-












      £2,300.00

      £1,280.00

      £2,254.00

      £2,570.00

      £5,420.00

      £460.00

      £580.00



      £650.00

      £620.00

      £540.00

      £1,600.00

      £1,260.00

      £850.00

      £2,800.00

      £1,040.00



      £- £24,224.00 £24,224.00








      £216,070.33
      £30,274.00
      £-






      £65,015.00


      £14,940.00


      £3,510.00


      £3,370.00


      £7,680.00


      £13,860.00


      £50,050.33


      £38,455.00


      £500.00


      £25,240.00





      £24,224.00







      £248,650.33
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        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