如图,C1公式:
=IF(((SUM($B2:B2)-$B2)>=$B2)+(SUM(C$1:C1)>SUM($B$2:$B$11)/COUNTA($C$1:$Z$1)),"",MIN($B2-(SUM($B2:B2)-$B2),SUM($B$2:$B$11)/COUNTA($C$1:$Z$1)-SUM(C$1:C1)))
右拉后下拉。
规划求解
C1:G11 =RANDBETWEEN(0,8)
C12 =SUM(C2:C11) 右拉填充到G12
H2 =SUM(C2:G2) 下拉填充到H11
B12 =SUM(C12:G12)