May 28 2023 08:50 AM
May 28 2023 09:03 AM
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?
May 28 2023 09:05 AM
May 28 2023 09:12 AM
May 28 2023 09:18 AM - edited May 29 2023 02:49 AMSolution
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)
May 29 2023 02:01 AM