SOLVED

# Formulas and function not working

Copper Contributor

# Formulas and function not working

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

# Re: Formulas and function not working

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?

# Re: Formulas and function not working

£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

# Re: Formulas and function not working

Hi Hans

best response confirmed by VI_Migration (Silver Contributor)
Solution

# Re: Formulas and function not working

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)

# Re: Formulas and function not working

Hans Vogelaar thank you for your responses, I managed to find where the issue was and it is now solved.

Many Thanks