=(COUNTIFS(Sheet1!D30:R30,$G$2,Sheet1!D6:R6,$F$2)+COUNTIFS(Sheet1!D30:R30,$G$2,Sheet1!D7:R7,$F$2)+COUNTIFS(Sheet1!D13:R13,$G$2,Sheet1!D11:R11,$F$2)+COUNTIFS(Sheet1!D13:R13,$G$2,Sheet1!D12:R12,$F$2))/2
=(COUNTIFS(Sheet1!D20:R20,$G$2,Sheet1!D18:R18,$F$2)+COUNTIFS(Sheet1!D20:R20,$G$2,Sheet1!D19:R19,$F$2)+COUNTIFS(Sheet1!D25:R25,$G$2,Sheet1!D23:R23,$F$2)+COUNTIFS(Sheet1!D27:R27,$G$2,Sheet1!D26:R26,$F$2))/2
I have a template sheets where the data in 12 rows apart cant seem to copy or drag this formula down
Bookmarks