+ Reply to Thread
Results 1 to 9 of 9

Golf Score Card

  1. #1
    Registered User
    Join Date
    07-23-2011
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Golf Score Card

    Hi guys, I'm in the process of creating a personal golf score card that would have a history of all the rounds of golf and # strokes at each hole.

    I've attached a screenshot of what I have so far to give you an idea.

    I'm having trouble figuring out the formula for an IF function. What I'd like to ask you excel experts is:

    How do I get D2 to calculate and automatically show how many Double Bogies I shot for Hole 1_85yds? A double bogey is 5 strokes in this case and I have made 3 Double Bogies at this particular hole in 10 games.
    Attached Images Attached Images

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,095

    Re: Trying to Make a Personal Golf Score Card

    Hello & Welcome to the Board,

    Try...

    =COUNTIF(F2:O2,5)
    HTH
    Regards, Jeff

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669

    Re: Golf Score Card

    If it were my score card, I'd just use =COUNT(F2:O2)

    Double bogeys are among my personal bests ...
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    07-23-2011
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Golf Score Card

    Quote Originally Posted by shg View Post
    If it were my score card, I'd just use =COUNT(F2:O2)

    Double bogeys are among my personal bests ...

    Wow I'm such a naive newb. Actually plugged that in and got a good laugh when I saw I had 10 Double Bogeys for 10 tries and then read your last comment. Very funny...

  5. #5
    Registered User
    Join Date
    07-23-2011
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Trying to Make a Personal Golf Score Card

    Quote Originally Posted by jeffreybrown View Post
    Hello & Welcome to the Board,

    Try...

    =COUNTIF(F2:O2,5)
    Thanks that worked great!!!!

  6. #6
    Registered User
    Join Date
    07-23-2011
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Golf Score Card

    My next questions would be:

    When I input a new round in Column P, the Double Bogey-CountIF column shows an error "Forumula Omits Adjacent Cells". Is there away to tweak the formula so that it includes any new entries so that I don't have to manually have to click "Update Forumla to include Cells"? I tried =COUNTIF(F2:2,5) but no luck.

    I am also having trouble figuring out the Conditional Formatting formula to show "Red Text for the most bogies" and "Green Text for the Least bogies" in that column D.

    I've attached the updated sheet I have so far.
    Attached Images Attached Images

  7. #7
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,095

    Re: Golf Score Card

    No problem. For the most or least, try the min and/or max functions. For the countif, can you expand the range or we could use a dynamic range

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,095

    Re: Golf Score Card

    See if this is something you can work with...
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Golf Score Card

    Here are a couple of sheets that I have used. You may get some more ideas.

    Jim O
    Attached Files Attached Files
    Last edited by JO505; 07-23-2011 at 06:10 PM. Reason: spelling typo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1