總計 單雙數以當下月份 (11033)


J6:K6=SUMPRODUCT((MOD($D2:$H99,2)=2-COLUMN(A1))*($D2:$H99<>"")*(TEXT($A2:$A99,"EM")=TEXT($J2,"EM")))


留言