How To Use The Count Function Like This?

Hello,

I have a question that I hope will be easy to resolve it has to do with the count function...

we will use cells:

D14
E14
F14
G14

J6
K6
L6

what I want to do is:

W's = WON
L's = LOST
T's = TIED

Count the W’s In cells D14 , E14 , F14 and when there is a W in these cells, I want the W's to count as (2)two when they are in cells D14 , E14 , F14

When there is a W in cell G14, I want that W to count as (1)one.

AND

the same for L's

In cells D14 , E14 , F14 and when there is a L in these cells, I want the L's to count as (2)two when they are in cells D14 , E14 , F14

When there is a L in cell G14, I want that L to count as (1)one.

AND FINALLY

the same for T's

In cells D14 , E14 , F14 , G14 and when there is a T in these cells, I want the T's to count as half of (1)one (0.5) when they are in cells D14 , E14 , F14 AND G14


The Formula's will go in cells J6 , K6 , L6

J6 = WON
K6 = LOST
L6 = TIED

I hope I'm explaing this right...

Thank You in advance

Hi

J6: =COUNTIF(D14:F14,"W")*2 + COUNTIF(G14,"W")
K6: =COUNTIF(D14:F14,"L")*2 + COUNTIF(G14,"L")
L6: =COUNTIF(D14:G14,"T")*0.5

rylo