統計個人依月份收支 (9049)

 

 G6:H9=SUMPRODUCT((TEXT($G$4,"EM")=TEXT($A$3:$A$11,"EM"))*($F6<>"")*ISNUMBER(FIND($F6,$B$3:$B$11))*C$3:C$11)