• 100% Satisfaction Guarantee

The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1758
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# I AM LOOKING FOR A FORMULA TO CONVERT A LETTER TO A SPECIFI

### Resolved Question:

I AM LOOKING FOR A FORMULA TO CONVERT A LETTER TO A SPECIFI NUMBER.

EXAMPLE: In horses a ringer (R) is 3 points and a Leaner (L) is 2 points
How can I put it in a excel sheet to say R or L is added to the total
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 2 years ago.

The-PC-Guy :

Hi, My name is Andrew

The-PC-Guy :

The-PC-Guy :

can you provide the formula you have so far?

Expert:  The-PC-Guy replied 2 years ago.

Hi, My name is Andrew

9:31 PM

9:31 PM

can you provide the formula you have so far?

Expert:  The-PC-Guy replied 2 years ago.
hi, you seam to have been disconnected.

are you saying tha you have a column that has Letters and Numbers in it and you want to sum the numbers and letters?
Customer: replied 2 years ago.

I can send you the excel sheet with the information in it and what the calculations answer should be

Expert:  The-PC-Guy replied 2 years ago.
that would work.

if you have a paperclip icon at the top of your chat window you can try clicking that. iT says image, but works on excel files
Expert:  The-PC-Guy replied 2 years ago.
if that does not work

try

www.wikisend.com

they will then give you a file ID#

paste that ID# XXXXX
Expert:  Richard replied 2 years ago.
Thank you for your question, my name is Richard.

I believe what you want to use is this formula

In this example, we are checking Cell A1

If(A1="R",3,if(A1="L",2,0))

So in this example, if R is in A1 you get a value of 3. If L is in A1 you get a value of 2.

We can expand this if you wish.

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you
Expert:  The-PC-Guy replied 2 years ago.

Lets assume that the column you want to sum is the D column and it contains letters and numbers.So assuming you want to sum cells D1 - D25, the following formula would help you

=SUM(D1:D25)+COUNTIF(D1:D25,"R")*3+COUNTIF(D1:D25,"L")*2

the way this works is the first part sums only the numbers, the second part counts all of the Rs and multiplies those by 3 and adds to previous total, the 3rd part does the same accept for the Ls

You can change the ranges if you need to.

Remember that the range (D1:D25) in this example is in 3 places in the formula, to apply it to your range, you would need to change in all 3 places to be the same range.

Let me know if you have any problems with this formula or need my help further

Customer: replied 2 years ago.

very close

Can I also do the same for a double ringer RR, Leaner LL

Also can a ringer plus closest to the pin work R1

(3 points for the ringer and 1 point for the other shoe?)

LL=4 points

RR=6 points

R1=4 points

L2=4points

So far everything is very close

Do you need me to send the excel sheet?

That way you can see what I am talking about?

There are 17 columns and 4 rows on the score sheet

4 players

Expert:  The-PC-Guy replied 2 years ago.
yes, sending the sheet would be the best way to accomplish this for you.

www.wikisend.com

they will then give you a file ID#

paste that ID# XXXXX

alternativelly you can try

www.ge.tt

Expert:  The-PC-Guy replied 2 years ago.
you can also add any criteria you want to the formula

so

=SUM(D1:D25)+COUNTIF(D1:D25,"R")*3+COUNTIF(D1:D25,"L")*2

if you want to add LL=4 points in you would just add

+COUNTIF(D1:D25,"LL")*4

so the new formula would look like

=SUM(D1:D25)+COUNTIF(D1:D25,"R")*3+COUNTIF(D1:D25,"L")*2+COUNTIF(D1:D25,"LL")*4

R1=4 points

+COUNTIF(D1:D25,"R1")*4

so the formula would be

=SUM(D1:D25)+COUNTIF(D1:D25,"R")*3+COUNTIF(D1:D25,"L")*2+COUNTIF(D1:D25,"LL")*4+COUNTIF(D1:D25,"R1")*4

and so on for as many criteria as you need.

but if you can get the sheet to me. I can do the formulas for you.

Whatever you prefer
Customer: replied 2 years ago.

WIKISEND FILE ID# XXXXX

Column U has what should be the correct answers.

Let me know

Thanks

Expert:  The-PC-Guy replied 2 years ago.
ok i got it

what are the values supposed to be for

H
RH
H1
Expert:  The-PC-Guy replied 2 years ago.
here is my solution.

I had to guess at the H, RH and H1 values because you didn't get back to me, but you can change the values to suit your needs.

http://ge.tt/3rrTn0u/v/0?c

PLEASE REMEMBER TO RATE MY SERVICE SO I AM REIMBURSED FOR MY TIME

if you need anything else let me know
Customer: replied 2 years ago.

That link brings up a virus alert and I can not open it.

H=2

H1=3

RH=5

Expert:  The-PC-Guy replied 2 years ago.
they will not let us email

but here is the formula for cell T3

let me know if it cuts off

=SUM(C3:S3)+COUNTIF(C3:S3,& quot;R")*3+COUNTIF(C3:S3,"H")*2+COUNTIF(C3:S3,"RH")*5+COUNTIF(C3:S3,"LL")*4+COUNTIF(C3:S3,"RR")*6+COUNTIF(C3:S3,"R1")*4+COUNTIF(C3:S3,"L2")*4+COUNTIF(C3:S3,"H1")*3

here is a text file containing the formula, cant possibly have a virus. And by the way the other file I sent didn't have a virus. That was a problem on your end

The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1758
Experience: 20 years experience providing remote computer support
Customer: replied 2 years ago.

Virus not here just AVG picked it up as one.

Anyway the last formulas worked out great

Thanks,

Expert:  The-PC-Guy replied 2 years ago.
no problem, I am glad everything worked out

---------------------------------------------------------------------------------------------------------------

if you have any questions in the future you can visit my profile

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
• Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland

• ### jstinehelfer

#### Satisfied Customers:

36
A+ Comptia Certified computer repair
< Last | Next >

### jstinehelfer

#### Satisfied Customers:

36
A+ Comptia Certified computer repair

### JasonJames122

#### Satisfied Customers:

0
I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

### Jess M.

#### Satisfied Customers:

481
Computer Software Specialist for more than 10 years

### The-PC-Guy

#### Satisfied Customers:

450
20 years experience providing remote computer support

### James K.

#### Satisfied Customers:

260
Technical Director of IT Company

### IT Miro

#### Satisfied Customers:

147
Bachelor's Degree in Information Technology, Microsoft Certified Professional