=(COUNTIFS(Sheet1!D8:R8,$G$2,Sheet1!D6:R6,$F$2)+COUNTIFS(Sheet1!D8:R8,$G$2,Sheet1!D7:R7,$F$2)+COUNTIFS(Sheet1!D13:R13,$G$2,Sheet1!D11:R11,$F$2)+COUNTIFS(

=(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 need it to fill a Monday to sunday 7 rows