Text equals a value

[Jokin]

Sorry if there is a post on here already but wondered if you can help. I have some football league statistics and I would like to make a letter equal a number and sum the results.

i.e I have the data

AFC FC Jokin W L D

I would like the W to equal 3, L to equal 0 and D to equal 1.

I would then like to sum these values to get the total points.

Any help is appreciated,

Thanks

[Paul]

If you want to count all the W's, L's and D's, then multiply each W by 3, L by 0 and D by 1, you could use something like:

=COUNTIF(C1:E10,"W")*3+COUNTIF(C1:E10,"L")*0+COUNTIF(C1:E10,"D")*1

Of course, why bother counting the L's if you're going to count them as 0 and then add 0 to the total?

[Jokin]

Thanks for your help Paul, done the trick