annual rankings

Hi there…

I am scoring for a club where we have 4-6 regatta per year that count towards final individual points. Is there a way to merge the results from each event into one series that 1)doesn’t change the regatta results, 2) will take the final results from each regatta and tally them as a score to get an overall result at year end to get a ranking for each competitor based on the events they participated in. Not everyone attends every event either so there would need to be a way of calculating points for non-attendees. … make sense?