不规则合併格求数量 (9180)

E2:G5{=SUM((LOOKUP(ROW($2:$33),ROW($2:$33)/($A$2:$A$33<>""),$A$2:$A$33)=$D2)*($B$2:$B$33=--LEFT(E$1)))