I have in Q118, this formula:

[]=IFERROR($Y$18*F111,0)+IFERROR($X$18*G111,0)+IFERROR($W$18*H111,0)+IFERROR($V$18*I111,0)+IFERROR($U$18*J111,0)+IFERROR($T$18*K111,0)+IFERROR($S$18*L111,0)+IFERROR($R$18*M111,0)+IFERROR($Q$18*N111,0)+IFERROR($P$18*O111,0)+IFERROR($O$18*P111,0)+IFERROR($N$18*Q111,0)][

I want to drag it to the left, so that it will go up to A118. Obviously, this gives #REF errors as the cells references go outside the sheet.

Is there a way to make this neater?

Thanks!