# Golf League - problem in calculating values

1. ## Golf League - problem in calculating values

Hi,

This forum was really helpful last year when i set up the golf league and the automated calculations of number of players and best top 5 scores has saved me countless hours of work.

I'm hoping someone can help with an issue I now have?

In the attached you will see I have a spreadsheet that records the number of birdies scored by each player in each round. I would like to do two things:

1. IF a score is entered in any week (columns), this means the player has played that week. I would like the Birdies Sheet to automatically assign a '0' value only against each player that has played that week (i.e. automatically assume no birdies have been scored by each player). I then manually enter the actual birdies for each player who has scored any that week. You will see that I have an auto calculation for the payouts for each player, depending on how many birdies they scored (10 pence payout per birdie). I have manually entered zeroes for those that played but didn't score birdies in the first week, but want this automated for all the following weeks
2. I would like the Earnings worksheet to take the 'Birdies' sheet values and multiply the number of birdies for each player each week by the payout/earnings calculation for each week. For example, on 29th October, Player 9, shot 3 birdies and received a net payout of £6.60 (cell B93)

I can then total the season winnings/losses per player

Really appreciate anyones' help with this.

Thanks

2. ## Re: Golf League - problem in calculating values

Try these formulas (made for Extra 1 Oct-9)
Birdies!B73:
Formula:
`Please Login or Register  to view this content.`

Earnings!B73:
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Golf League - problem in calculating values

Thanks so much for this. WRT the earnings calculation, how would I modify the formula to only calculate a result if the player actually played that week (i.e. posted a score in the Golf Winter league Sheet)?

4. ## Re: Golf League - problem in calculating values

Formula:
`Please Login or Register  to view this content.`

5. ## Re: Golf League - problem in calculating values

Originally Posted by k64
Formula:
`Please Login or Register  to view this content.`
That's just brilliant, thanks again!!

6. ## Re: Golf League - problem in calculating values

No problem. Thanks for the +Rep. Glad I could help!

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

#### 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