Sorry, the title is not that clear, but this is what I want to do...
I have a spreadsheet that has a row of cells that look like this, one for each competitor
1st 2nd 3rd
These are results from a competition, and in the third case no result was obtained. Each result has an associated score, which is defined on a separate sheet (this also defines the validation for the cells);
0 1st 5 2nd 4 3rd 3 Commended 1
What I want to be able to do is create a sum of the scores for a competitor, based upon the placings displayed on the spreadsheet. So for the example given, where there are 4 results, one of which is blank, the competitor would score (5 + 4 + 3 = 12).
Using the example above, the result would look something like this;
Fred Bloggs 1st 2nd 3rd 12
How would I go about this? There will be 12 columns of scores, and of course multiple rows, one for each competitor.
Any help or guidance is much appreciated.
Thanks in anticipation
Bookmarks