SOLVED

Formulas and function not working

Copper Contributor

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)

5 Replies

@Timi_Hysaj 

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?




£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
Hi Hans
Thank you for your reply

Please see the link from OneDrive https://1drv.ms/x/s!AokLj2Wb5UDWkguEu9AwrTWodL4A?e=VK80jG
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Timi_Hysaj 

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
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Timi_Hysaj 

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)

View solution in original post