英文月份總和 (13056)

H3=SUMPRODUCT((YEAR(B$3:B$10)=YEAR(NOW()))*(TEXT(B$3:B$10,"MMM")=G3)*C$3:C$10)



留言