總計 分當下年月日 (13541)

G3:L5=SUMPRODUCT((TEXT($A$2:$A$9999,CHOOSE(MOD(COLUMN(A1)-1,3)+1,"E/M/D","E/M","Y"))=TEXT($N$2,CHOOSE(MOD(COLUMN(A1)-1,3)+1,"E/M/D","E/M","Y")))*($B$2:$B$9999=$F3)*($C$2:$C$9999=LOOKUP("龜",$G$1:G$1))*$D$2:$D$9999)