Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
Convert text numbers to numbers | Excel Worksheet Functions | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |