Golf Scoring System

[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.

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

 

[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.

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