I am trying to create trap shooting score sheet with peoples averages. Not everyone shoots each week. Shooters names are a drop down list. Currently Hits counts "blanks" (countblank formual). Blue columns score each lane. Shooter shoots 5 times then rotates to a new lane, 5 lanes total. 25 shots per round. Team total subtracts lowest score, =SUM(F8:F13)-SMALL(F8:F13,1).
My problem is getting the averages to work properly for percentages. =AVERAGEIFS(Hits,Yardage,"16",ShooterName,C9)/SUMIFS(ClayPerRound,ShooterName,C9,Yardage,16)
My other problem (biggest) is getting the Lane averages right. Cell I10 equation is "=AVERAGEIFS(Lane1,Yardage,"16",ShooterName,$C9)" This just says what their first 5 shots where, not relative to the lane. Example: shooter 5 starts on lane 5, but his score is the first 5 shots not shots 21 to 25. How do I average out per location?
My problem is getting the averages to work properly for percentages. =AVERAGEIFS(Hits,Yardage,"16",ShooterName,C9)/SUMIFS(ClayPerRound,ShooterName,C9,Yardage,16)
My other problem (biggest) is getting the Lane averages right. Cell I10 equation is "=AVERAGEIFS(Lane1,Yardage,"16",ShooterName,$C9)" This just says what their first 5 shots where, not relative to the lane. Example: shooter 5 starts on lane 5, but his score is the first 5 shots not shots 21 to 25. How do I average out per location?