Golf Scoring System

J

jtroutman

Hello,

I have been trying to use the answers to other replies, but it is not
working for me.

What I have is 7 columns for scores (d through j), handicap in column
c, name in column a and b.

What I need is a formula that will calculate the lowest 2 golf scores
they have posted with no handicap and with handicap. There will be
blanks. I cannot get around the zeros.:rolleyes:

Attachment filename: kansas cup3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=555799
 
C

Chris M

-----Original Message-----
Hello,

I have been trying to use the answers to other replies, but it is not
working for me.

What I have is 7 columns for scores (d through j), handicap in column
c, name in column a and b.

What I need is a formula that will calculate the lowest 2 golf scores
they have posted with no handicap and with handicap. There will be
blanks. I cannot get around the zeros.:rolleyes:

Attachment filename: kansas cup3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=555799
---


.
Hey there I looked over your sheet and since I do not
play golf this is different
First thing first: Sheet rows K and L get rid of the plus
signs and use a sum formula that will take care of some of
the errors you are getting.
Example =sum(D3:J3)
Next I looked at the formula in cell K4 it is changed the
first part using the sum formula that helped but you have
the #DIV0! error this is due to the fact that the cell
referenced in the formula "Sheet2!I4" is blank.

OK now to sheet2
Cell G9 change your formula to this:
=IF(ISNUMBER(G8),G8-Sheet1!C4,"")and due the same to cell
H9 modifying the formula as needed of course. As for cells
A21 and A22 click in the cell hit the f3 key to edit the
formula then push the "ctrl", "shift" and the "enter" keys
at the same time and that will fix the #VALUE! error, the
formula for an AVERAGE is an array and this is how it is
entered.

Well hope this helps you!!
Have a great day!!
Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top