Thanks. In F4 and G4, I accidentally wrote B5 twice instead of B2 and B5 (I've bolded the changes). Here are the correct formulae:
F4:
Formula:
=AVERAGE(INDEX('Total Error %'!B:B,MATCH(B2,'Total Error %'!A:A,0)+1),INDEX('Total Error %'!B:B,MATCH(B5,'Total Error %'!A:A,0)))
G4:
Formula:
=AVERAGE(INDEX('Total Error %'!C:C,MATCH(B2,'Total Error %'!A:A,0)+1):INDEX('Total Error %'!C:C,MATCH(B5,'Total Error %'!A:A,0)))
But the cells they are referring forward to are also customized as "YY/MM", so it should not be a problem, should it?
Bookmarks