using text and numbers
 

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

using text and numbers
 

Try =Sum(B2:B10) or =Sum(B2:D2) to ignore errors

--

Tommy Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532120

using text and numbers
 

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

using text and numbers
 

"Tommy" wrote:
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.

Assuming the source table below is in Sheet1,
cols A to D, from row1 down

Name score score total
Player DQ DQ DQ

In a new Sheet2,

Put in A1:
=IF(Sheet1!A1="","",IF(Sheet1!A1="DQ",0,Sheet1!A1) )

Copy A1 to D1, fill down to say, D50
to cover the max expected extent of the table in Sheet1

Sheet2 will return the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

using text and numbers
 

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

using text and numbers
 

Try

=IF(SUM(A1:B1)0,SUM(A1:B1),IF(COUNTIF(A1:B1,"DQ") 0,"DQ",""))

or, for three rounds A to C,

=IF(SUM(A1:C1)0,SUM(A1:C1),IF(COUNTIF(A1:C1,"DQ") 0,"DQ",""))

--

Tommy Wrote:
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





--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532120

using text and numbers
 

"Tommy" wrote:
name score score total
player DQ 72 72

Another play to try, adapted from a post by Peo y'day,

Place in D2:
=IF(COUNTIF(B2:C2,"DQ")=2,"DQ",SUMPRODUCT(--(0&SUBSTITUTE(B2:C2,"DQ",""))))
Copy down

Adapt the ranges & the COUNTIF(...)= #
to suit the number of cols for the scores
(the formula above is for the sample data posted
which shows 2 score cols in cols B & C)

#: If there's 18 score cols, use COUNTIF(...)=18
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---