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)
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