加總 固定合併格數 (14033)

H3:H4=SUMIFS(C2:C19,A$2:A$19,"*"&F3,B2:B19,G3)

另解=SUMPRODUCT((RIGHT(A$2:A$19,2)=F3)*(B2:B19=G3)*C2:C19)

另解=SUMPRODUCT((RIGHT(A$2:A$19,2)=F3)*OFFSET(C$2:C$19,G3="未兑",))