=SUMPRODUCT((DAY(Sheet1!$F$2:$F$65)=DAY(H$1))*((Sheet1!$R$2:$R$65=$C2)+(She et1!$T$2:$T$65=$C2)+(Sheet1!$V$2:$V$65=$C2))*(Sheet1!$AF$2:$AH$65))
+SUMPRODUCT((DAY(Sheet2!$F$2:$F$65)=DAY(H$1))*((Sheet2!$R$2:$R$65=$C2)+(She et2!$T$2:$T$65=$C2)+(Sheet2!$V$2:$V$65=$C2))*(Sheet2!$AF$2:$AH$65))