Forum Discussion
Formulas and function not working
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)
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?
- Hi Hans
Thank you for your reply
Please see the link from OneDrive https://1drv.ms/x/s!AokLj2Wb5UDWkguEu9AwrTWodL4A?e=VK80jGThe 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)
£24,640.00 £600.00 £25,240.00
£640.00
£1,200.00
£860.00
£1,100.00
£3,800.00 £-
£2,300.00
£1,280.00
£2,254.00
£2,570.00
£5,420.00
£460.00
£580.00
£650.00
£620.00
£540.00
£1,600.00
£1,260.00
£850.00
£2,800.00
£1,040.00
£- £24,224.00 £24,224.00
£216,070.33
£30,274.00
£-
£65,015.00
£14,940.00
£3,510.00
£3,370.00
£7,680.00
£13,860.00
£50,050.33
£38,455.00
£500.00
£25,240.00
£24,224.00
£248,650.33
