合併格小計 設定最大值後 總計 (12956)

H5:H13 合併格公式=IF(D5="","",SUM(IF(MMULT(COLUMN(A:I)^0,(LOOKUP(ROW($5:$13),ROW($5:$13)/(B$5:B$13<>""),B$5:B$13)=B5)*D$5:F$13)>G5,G5,MMULT(COLUMN(A:I)^0,(LOOKUP(ROW($5:$13),ROW($5:$13)/(B$5:B$13<>""),B$5:B$13)=B5)*D$5:F$13))))