I'm hoping a guru here can help before my hairline recedes further! I've been trying to create an electronic score sheet for an Archery championship. At each event a competitor gets a score that consists of a total and the number of bullseyes they hit. Example: a total of 99 and 6 bullseyes. They have 20 events for the year, and the best 12 events' totals count towards your championship aggregate.

I've found I can return the sum for the best 12 event totals using the following formula:

SUM(LARGE(J4:J26,{1,2,3,4,5,6,7,8,9,10,11,12}))

What I can't work out is how to return the associated bullseye counts for those best 12 event totals!

I've tried using: Sum(large(offset(j4:j26,0,1),{1,2,3,4,5,6,7,8,9,10,11,12} but this returns the sum of the top 12 bullseye counts for the year rather than returning the sum of the bullseyes that relate to the events with the highest total score.

I have looked at some of the other posts here regarding the offset and large formulas but I couldn't find any that with my skills I could adapt to work. Any help would be greatly appreciated.

Thanks,

Shaz