Okay try this
Note that Your formula refers to Cells H1 & I1.
I have put the values in these cells from J1 & K1
In E4
=((OFFSET(INDIRECT($H$1&"!E"&ROW(A4)),0,COLUMN(A$1)-1)
+OFFSET(INDIRECT($I$1&"!E"&ROW(A4)),0,COLUMN(A$1)-1))/2)
*(Settings!$F$6+1)
Drag Across and then Down
If you need a whole number try
=INT(((OFFSET(INDIRECT($H$1&"!E"&ROW(A4)),0,COLUMN(A$1)-1)
+OFFSET(INDIRECT($I$1&"!E"&ROW(A4)),0,COLUMN(A$1)-1))/2)
*(Settings!$F$6+1))
If all the sheets are in the one workbook, why not use in E4
=(Settings!F6+1)*((PrSales_10!E4+PrSales_11!E4)/2)
Drag Across and then Down
Hope this helps
Bookmarks