销售额 年月日 (9957)

F2:H2{=SUM((CHOOSE(COLUMN(A1),$A$2:$A$16,TEXT($A$2:$A$16,"EMM"),YEAR($A$2:$A$16))=CHOOSE(COLUMN(A1),$D2,TEXT($D2,"EMM"),YEAR($D2)))*$B$2:$B$16)