總和 以月分計算 (11840)

F2=SUMPRODUCT((TEXT(E2,"em")=TEXT(B$2:B$16,"em"))*C$2:C$16)

另解=SUMIFS(C:C,B:B,">"&EOMONTH(E2,-1),B:B,"<="&EOMONTH(E2,0))

另解=SUMPRODUCT((LOOKUP(B$2:B$16,EOMONTH(E2,{-12,-1,0})+1,{0,1,2})=1)*C$2:C$16)