只考慮月與日 取數值 (15278)

F2:I7=SUMPRODUCT((TEXT($B$2:$B$21,"M/D")=COLUMN(A1)&"/"&$E2)*$C$2:$C$21)

F12:I17{=IFERROR(VLOOKUP(COLUMN(A1)&"/"&$E2,IF({1,0},TEXT($B$2:$B$21,"M/D"),$C$2:$C$21),2,),"")