Need % found for golf stat spreadsheet that needs % for data inputed onto spreadsheet

**krausen** · 06-06-2009, 01:16 PM

I searched the site and couldn't find help for my problem.

I am new to excel and only know the basics.

I have been working on a spreadsheet to keep track of my golf game.

I really need to get a couple things fixed.

First thing I need fixed is I really need row AE to show the % hit.

Can someone tell me the forumla to use for this?

I also need row AF to show the average yardage.

Thanks in advance.

Forgot to mention I am talking about the Brighton (White Birch) page.

**JBeaucaire** · 06-06-2009, 01:27 PM

Since you have provided no information about you mean by %, can't help there.

Since you have provided no DATA regarding the drive yardage, I'll show you you could do it. In cell AF13, this formula shows what the average HOLE YARDAGE is:

=SUM(K13,U13)/COUNT(B13:J13,L13:T13)

Now, copy that cell down to AF16 and you will get results when you actually put data into row 16. Likewise for row 23, etc.

Now, to keep the errors from showing on an empty score card, use this in AF16, then copy to appropriate other rows:
=IF(COUNT(B16:J16, L16:T16) = 0, "", SUM(K16,U16) / COUNT(B16:J16, L16:T16))

**JBeaucaire** · 06-06-2009, 01:30 PM

Does this give you what you want for fairway percentages, in cell AE15:

=COUNT(B15:J15,L15:T15)/18 (format as percentage)

**krausen** · 06-06-2009, 01:43 PM

I didn't put info because I haven't started to track that data yet.

As far as % goes I was looking for % that hit fairway.

For instance there are 14 chances per 18 holes because PAR 3 does not count.

If I hit 3 out of 14 I would like it to keep track of the % hit.

I will know if the yardage worked later this weekend when I actually start keeping track.

Thank you

**JBeaucaire** · 06-06-2009, 01:52 PM

Try this formula in AE14, widen the column, format as a percentage, should result in 29%:

=COUNT($B15:$J15,$L15:$T15)/(COUNTIF($B$12:$J$12,">3")+COUNTIF($L$12:$T$12,">3"))

**arthurbr** · 06-06-2009, 02:46 PM

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 on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.