finding certain letters and returning a value

[happyman123uk]

I have a spread sheet which I am working on and want to be able to say if a certain letter is entered into a cell it returns a certain value

W=3 points
D=1 point
L=0 points

so if

a1=W
a2=L
a3=W
a4=D
a5=W
a6=L
a7=W
a8=W

a9 would contain the answer which should be 16

 

[jtakw]

Hi,

Try:

Excel 2010
	A
1	W
2	L
3	W
4	D
5	W
6	L
7	W
8	W
9	16
Sheet1

Cell Formulas
Range	Formula
A9	=COUNTIF(A1:A8,"W")*3+COUNTIF(A1:A8,"D")

 

[Joe4]

Try:

=(COUNTIF(A1:A8,"W")*3)+COUNTIF(A1:A8,"D")

 

[happyman123uk]

Thank you so much one more problem sorted

 

[jtakw]

You're welcome.

 

[Scott Huish]

=sum(countif(a:a,{"w","d"})*{3,1})