Can any help me find the correct formula? The lowest score will depend on the number of players scores needed. In this case we needed two player's scores, so the lowest total score is 7, but if we needed 3 scores our total will be 11. Thanks, any help will be appreciate!
Oeldere, thank you for helping me out, but every time I try to put the formula anywhere below the fourth row the formula does not work. Thus this means that every fomula must above fourth column? Thanks, usc1000
I am currently at work, but I will give it a try once I get home or over the weekend. I am not very good at decipher formulas as you have explain it, but anytime I added the formula "small($B$1:$B$4,ROW()) and placed it on e1 and drag down it work well, even if I put on f1 and drag id down it would work okay, but as soon as I would drag the formula from the cell and place it anywhere from e5 or any other column " "5 and down it would not work. Hopefully this new process works. Thanks! P.S. I do appreciate all your help and specially the process of the explanation, this makes me understand how the formula works. Once again, thanks.