上月與本月最末金额 (10533)


F2:G4{=RIGHT(MAX((TEXT(EOMONTH($I$2,COLUMN(A1)-2),"YYYMM")=LEFT($B$2:$B$8,6))*($A$2:$A$8=$E2)*($B$2:$B$8*10^5+$C$2:$C$8)),5)*1


留言