IFERROR WITH INDEX

[ozbeachbum]

Hi All,
I have 3 workbooks WB3 requires a formula to bring data from WB1 & 2 and divide by a number in WB3, however their will be occasions when their will be a ZERO.
I have successfully used the following formula, however as it is OFFSET it requires the other WB's to be open.
=(IFERROR((OFFSET('[WB1.xlsx]ACL'!$Q$73,(ROW(Q1)-1)*6,0)*OFFSET('[WB1.xlsx]ACL'!$Q$72,(ROW(Q1)-1)*6,0)
+OFFSET('[WB2.xlsx]SAD'!$CJ$70,(ROW(BJ1)-1)*6,0)+OFFSET('[WB2.xlsx]SAD'!$CN$70,(ROW(BI1)-1)*6,0))/U70,
OFFSET('[WB1.xlsx]ACL'!$Q$73,(ROW(Q1)-1)*6,0)))
To elevate the necessity for the other WB's to be open I tried using INDEX, and received to few arguments error message.
=(IFERROR(INDEX('[WB1.xlsx]ACL'!$Q$73:$Q$333,(ROWS($A$1:$A1)-1)*6)+1)*INDEX('[WB1.xlsx]ACL'!$Q$72:$Q$332,(ROWS($A$1:$A1)-1)*6)+1)
+INDEX('[WB2.xlsx]SAD'!$CJ$70:$CJ$73,(ROWS($A$`:$A1)-1)*6)+1)+INDEX('[WB2.xlsx]SAD'!$CN$70:$CN$73,(ROWS($A$`:$A1)-1)*6)+1))/U70,
INDEX('[WB1.xlsx]ACL'!$Q$73:$Q$333,(ROWS($A$1:$A1)-1)*6)+1)))
Any assistance with a formula so the other workbooks do not need to be open would be greatly appreciated.

 

[Fluff]

Maybe

=IFERROR((INDEX([WB1.xlsx]ACL!$Q$73:$Q$333,(ROWS($A$1:$A1)-1)*6+1)*INDEX([WB1.xlsx]ACL!$Q$72:$Q$332,(ROWS($A$1:$A1)-1)*6+1)+INDEX([WB2.xlsx]SAD!$CJ$70:$CJ$73,(ROWS($A$1:$A1)-1)*6+1)+INDEX([WB2.xlsx]SAD!$CN$70:$CN$73,(ROWS($A$1:$A1)-1)*6+1))/U70,INDEX([WB1.xlsx]ACL!$Q$73:$Q$333,(ROWS($A$1:$A1)-1)*6+1))

 

[ozbeachbum]

Thanks again Fluff.
Do you get the Super Rugby Pacific in England?

 

[Fluff]

Do you get the Super Rugby Pacific in England?

Nope. Not unless it's on Sky which I don't have.

 

[ozbeachbum]

You will have the World Cup close to you, a short hop across the channel.
Now we have Eddie back as head coach the Wallabies might put in a good show.
All the best.
Dave.