I am trying to create a summary score sheet to find a High point winner. The program has an Entries sheet where names are entered and marked as to which ‘classes’ they are participating in. (there are 12 classes) Each class has it’s own sheet. The competitors receive a set of scores for each class which is totaled and sorted High to Low. Of a total of 30 competitors maybe 10 are in one class, they can enter several classes. 

I want to create a summary of their scores. A summary page uses this formula (=IF(Entries!$A4<>””,Entries!B4,””) to copy their names to the summary. The problem is for ‘Class A’ when the scores are tallied and sorted, the total does not match the competitor input line anymore. I can total a score if I chose a specific cell (=’#1 (Saturday)’!T6) but it does not relate to that competitor…  Is there a way to sort that out?

​I am trying to create a summary score sheet to find a High point winner. The program has an Entries sheet where names are entered and marked as to which ‘classes’ they are participating in. (there are 12 classes) Each class has it’s own sheet. The competitors receive a set of scores for each class which is totaled and sorted High to Low. Of a total of 30 competitors maybe 10 are in one class, they can enter several classes. I want to create a summary of their scores. A summary page uses this formula (=IF(Entries!$A4<>””,Entries!B4,””) to copy their names to the summary. The problem is for ‘Class A’ when the scores are tallied and sorted, the total does not match the competitor input line anymore. I can total a score if I chose a specific cell (=’#1 (Saturday)’!T6) but it does not relate to that competitor…  Is there a way to sort that out?  Read More

​