D2:E19=IF(MOD(ROW(A1),4),OFFSET(A$2,INT(ROW(A1)/4),)&"",REPT("Total :",$A$1=A$1))
G2:G19{=IF(D2="","",IFERROR(INDEX(FREQUENCY(IF(MONTH(DATE(D2,E2,ROW($1:$31)))-E2=0,MOD(DATE(D2,E2,ROW($1:$31))-2,7)+1),{5,6}),MOD(ROW(A1),4)),SUM(G$1:G1)-SUMIF(F$1:F1,"",G$1:G1)*2))
留言
張貼留言