scores | |||||||
Player1 | 4 | ||||||
Player2 | 6 | ||||||
Player3 | 3 | ||||||
Player4 | 4 | ||||||
Number of player's score needed | 2 | ||||||
lowest total score | 7 |
<tbody>
</tbody>
scores | |||||||
Player1 | 4 | ||||||
Player2 | 6 | ||||||
Player3 | 3 | ||||||
Player4 | 4 | ||||||
Number of player's score needed | 2 | ||||||
lowest total score | 7 |
Player1 4 3
Player2 6 4
Player3 3 4
Player4 4 6
Number of player's score needed 3
lowest total score 11
E1 = =SMALL($B$1:$B$4,ROW()) and drag down
=> this give the result 3, 4 , 4, 6 in E1 : E4
B6 = manualy added the number of players (in this case 3)
B7 = =SUM(INDIRECT("E1"&":"&"E"&1+$B$6-1))
Please reply
ADVERTISEMENT
e1=SMALL($B$1:$B$4,ROW())
the part row() in cel e1 give as result (row1) = 1.
e2 will give the result 2
if you want to put the formula in cel e10 and you want the result 1, then you have to amend the formula.
e10=> row()-9 =1
e11=> row()-9=2
Hope I explained well enough, why the formula is NOT working if you put it somewhere else in the file.
place it anywhere from e5 or any other column " "5
B7 = =SUM(INDIRECT("[COLOR="#FF0000"]E1[/COLOR]"&":"&"[COLOR="#FF0000"]E[/COLOR]"&1+$B$6-1))
Code:place it anywhere from e5 or any other column " "5
Code:B7 = =SUM(INDIRECT("[COLOR=#ff0000]E1[/COLOR]"&":"&"[COLOR=#ff0000]E[/COLOR]"&1+$B$6-1))
If you put your formula in another column you need to amend the column in the red text above.