各項費用 統計本年月日(13736)

H2:K5{=SUM(ISNUMBER(FIND(I$1,$B$1:$G$1))*$B$2:$G$9999*CHOOSE(ROW(A1),1,YEAR($A$2:$A$9999)=YEAR($M$2),TEXT($A$2:$A$9999,"EM")=TEXT($M$2,"EM"),$A$2:$A$9999=$M$2))



留言