家庭開銷 依年月取資料 (13845)

G2右拉=RIGHT(TEXT(DATE($G$1,$J$1,G2),"AAA"))

F4 下拉{=IFERROR(INDEX(B:B,SMALL(IF((DATE(G$1,J$1,1)=IFERROR(EOMONTH(IF({1},A$2:A$999),-1)+1,))*(COUNTIF(F$3:F3,B$2:B$999)=0),ROW($2:$999)),1)),"")

G4 右拉 下拉=TEXT(SUMPRODUCT((DATE($G$1,$J$1,1)=IFERROR(EOMONTH(IF({1},$A$2:$A$999),-1)+1,))*($B$2:$B$999=$F4)*(DAY($A$2:$A$999)=G$2)*$C$2:$C$999),"0;;")