Averaging Data not in consecutive cells with data in-between

Hi guys,

I'm trying to do multiple things, but they are similar. What's the easiest way to average scores in column L? I'm sure there's an easier way than =average(L1,L6,L11...) That would seem to take quite some time to go thru all those rows. I also need to be able to have sum totals of "Score", "Putts", "GIR", and "Fairways" for C:K. I don't know how to add all Scores in column C without doing this...=sum(c1+c6+c11...etc)

The "stats" for those columns would "appear" in their proper spots in the "April" stats in rows 66-74. I have filled in the simple formulae for those categories. For GIR Putt, I need the sum of c2 etc. (putts) to appear if the CHAR(180) was in the C3 cell. As you can see, I don't even know how to do that for JUST 1 round. The formula for Up/Downs-Made would be something like this. Let's use Column D. That hole is a par 3. There was not a GIR (no CHAR 180), but the score was 3 or less. Therefore, that was an U/D-M. (So, if there was not a CHAR(180) in the cell and the score in C1:K1 was par or better, that would be counted as an U/D-M) In case needed, here are the pars for the holes in question.
4-3-5-4-3-4-4-4-4 = 35 total.

Thanks

BL84

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)