總和 空白格同上 (9558)

名称次序需相同=SUMPRODUCT((SUBTOTAL(3,OFFSET($B$2,,,ROW($1:$19)))=ROW(A1))*($C$2:$C$20=G$1)*$D$2:$D$20)

另解=SUMPRODUCT((LOOKUP(ROW($2:$20),ROW($2:$20)/($B$2:$B$20<>""),$B$2:$B$20)=$F2)*($C$2:$C$20=G$1)*$D$2:$D$20)