Formulas and function not working

Copper Contributor

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)

5 Replies


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?

£24,640.00 £600.00 £25,240.00





£3,800.00 £-
















£- £24,224.00 £24,224.00













Hi Hans
Thank you for your reply

Please see the link from OneDrive!AokLj2Wb5UDWkguEu9AwrTWodL4A?e=VK80jG
best response confirmed by VI_Migration (Silver Contributor)


The SUM formula in B436 is




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




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

Hans Vogelaar thank you for your responses, I managed to find where the issue was and it is now solved.

Many Thanks