公式像这样：=SUMPRODUCT((A$2:A$100=INDEX(D$2:D$8,INT(ROW()/2)))*(B$2:B$100=INDEX(E$2:E$8,ROW())),C$2:C$100)
F2=sumifs(c:c,a:a,indirect(address(int(row(a2)/2),4)),b:b,e2) 下拉填充
