Maths for a scoring system..

Thanks for your reply JB.
I'm not sure if all this is possible with Excel, and I'm not great at maths, so at the risk of embarassing myself, I'll try to continue! ..

The first idea I had was a "weakest link" system, where the lowest of the three points causes a penalty on the overall score, so for example, 10,10,2 would be penalized significantly against 4,4,5 ....

Not sure if you can automatically find the lowest number in Excel...

Another system, which I imagine could be more straightforward, would be a bonus system (if/else?), where addition is used, and a fourth parameter ("B" for "bonus") is brought in. This could be the lowest number, times three.
Then the formula looks something like (T+A+S+(Bx3))
In that case, 10,10,1 would end up with a bonus of 2, and an overall score of 23, while 4,4,4 would get a score of 24.
3,3,3 would give a score of 18, and while this is still lower than the 10,10,1, scores of 10,10,1 and similar would be extremely rare regardless.
The real downside is that something can still get reasonable points, even when one of the parameters has a ZER0

And again, not sure if you can automatically find the lowest number in Excel...

Pete, I hadn't thought of that approach, but there is a problem with using the differece between the biggest and smallest numbers as it doesn't give enough weight to those combinations with larger numbers, e.g., 3,3,3 would actually beat 9,5,3...