this will probably be the only question I ever ask,

just like healimonster I have a competition sheet
and just like healimonster I had some trouble getting it to work correctly

Palmetto solved one big problem with the index formula wich I found out does also do second place
my thanks for that one by the way

my club has a Personal Ranking system we try to make digtal

my sheet book contains a series of pool sets in wich 4 or 5 play against all in the pool
(wich always worked ok and this part gives me 8 players for the next)

and a final 8 drop-out competition that now works partly
(I get the names of the winners to the final place)

the thing I need to work is the scores from the players
to add up with these final 8 winnings
so that my personal ranking page takes the total scores

my final 8 winners shift by index formula and take a score after the name
so basicly I use 2 columns for all steps of the drop-outs

is there a way to add all score fields that are coupled to the maching name-fields ?
if there is my workbook will be fully operational



the details for my system:
I work on excell 2000 and without the vba
the basic was never installed