本年 月 日 三種選擇 計總和 (15322)

K2=SUMPRODUCT((TEXT(I2,CHOOSE(I7,"YYY/M/D","YYY/M","YYY"))=TEXT(B2:B16,CHOOSE(I7,"YYY/M/D","YYY/M","YYY")))*(C1:G1=I16)*C2:G16)

B2:B16格式化=TEXT(I$2,CHOOSE(I$7,"YYY/M/D","YYY/M","YYY"))=TEXT(B2,CHOOSE(I$7,"YYY/M/D","YYY/M","YYY"))