數據彙整 (12151)

B3:K9=TEXT(SUMPRODUCT((LOOKUP(99,$B$1:B$1)=DAY($N$2:$N$12))*($A3=$M$2:$M$12)*(B$2=$O$1:$P$1)*$O$2:$P$12),"0;;")