Biff

yes it is possible to have

name score score total
player DQ 72 72

is there a formula that will do this

"Biff" wrote:

Hi!

Try this:

=IF(COUNTIF(B2:C2,"DQ"),"DQ",B2+C2)

You're post is kind of vague, however.

Is it possible to have both a score and a DQ at the same time:

Name score score total
Player 77 DQ ???

Biff

"Tommy" wrote in message
...
I want to add a row of golf scores, but sometimes you have to put letters
instead of numbers. Can I do this and have it input the letters or if
numbers use them

Name score score total
Player DQ DQ DQ

That is what I want it to look like, but I can't get it to see letters, so
I
input 0 for the score. Can this be done.

thank you