Excel Spreadsheet Dlookup

I am looking for someone to help me complete this spreadsheet that i am working on.

There are 2 tabs in this spreadsheet Results and Scores

I will manually type mine and my friends scores into the scores tab every time we play. What i would like to happen then is excel does a count of how many bogeys (1 over the par) Par's or Birdies (1 under the par) that we have each got and record it in the Results view.

I have tried a Dlookup and i am not sure if this is even possible, please look at the spreadsheet to get a better idea.

Thanks for your help. golf.xls
LVL 6
CaptainGibletsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

answer_dudeCommented:
DCOUNT allows you to apply complex criteria to a data set.  In your case you want to apply criteria to a calculation of a dataset... (scores - par), so you need to create that data set first.

See attached.  I've updated your Scores sheet to have one line per player and I've updated the results sheet to be completely formula driven.
golf.xls
0
CaptainGibletsAuthor Commented:
thanks for that. Is there any way to automatically hide the fields in the results page that are calculating blank cells? or will i just have to unhide 2 extra columns each time that we play enter new results.
0
answer_dudeCommented:
I've done it by using an IF statement... there's probably another way with conditional formatting -- but this works.

Just don't forget to copy additional rows on the results sheet when you get to the bottom.  You can just copy the last row down as you enter new games beyond row 30.
golf.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CaptainGibletsAuthor Commented:
thanks a lot for your help works great.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.