Forum Discussion
Formulas and function not working
- May 28, 2023
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)
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)
Many Thanks