Ron, I had to change the COUNT function to >0 since it is possible for someone to participate in only one event and still get points. Also, when I put in a score of 57 or higher, I get an "8" in the AD6 cell, so I had to take out the ";0;0" in the MATCH function. It appears to work now, not that I really understand the whole MATCH functions and the K6+COLUMN(K6)/10000 references.
Bookmarks