Forum Discussion
Formulas and function not working
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)
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?
Thank you for your reply
Please see the link from OneDrive https://1drv.ms/x/s!AokLj2Wb5UDWkguEu9AwrTWodL4A?e=VK80jG
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)
- Hans Vogelaar thank you for your responses, I managed to find where the issue was and it is now solved.
Many Thanks