Do you want a shot by shot scoreboard, or do you just want to keep records of
total scores per shoot?

Shot by shot: Col A = Name of Shottist, Col B Membership nr, Col C:AA
contains either "0" or "1" for your 25 shots, Col AB is the score for the
shoot. Formula = IF(SUM(C2:AA2)=0,"",SUM(C2:AA2)). You can get fancy and
devide the 25 shots into the five stations if you wish. All depends on what
stats you want to be able to pull.

Total Scores is very straightforward, having name, number and score.


"Ed in Mesquite, TX" wrote:

We would like to keep records of scores on an Excel file. Anyone been there?