找對應值 依季節與姓名 (14164)

C2=SUMPRODUCT((ROUNDUP(MONTH(A2)/3,)&"季節"=G$2:G$17)*(B2=H$2:H$17)*I$2:I$17)

另解=LOOKUP(1,0/(ROUNDUP(MONTH(A2)/3,)&"季節"=G:G)/(B2=H:H),I:I)

另解=SUMPRODUCT((LEN(2^MONTH(A2))&"季節"=G$2:G$17)*(B2=H$2:H$17)*I$2:I$17)