May 28 2023 08:50 AM
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)
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 AM
SolutionThe 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)
May 29 2023 02:01 AM
May 28 2023 09:18 AM - edited May 29 2023 02:49 AM
SolutionThe 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)