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
Bookmarks