年月将数值汇总求和 (11114)

E2=SUMPRODUCT((TEXT(A$2:A$9,"EM")=TEXT(D2,"EM"))*B$2:B$9)

D列無 1日有誤=SUMPRODUCT((EOMONTH(--A$2:A$9,-1)+1=D2)*B$2:B$9)