determining won-loss record

[bubba1965]

I am wondering if someone can help me with a formula for determinin
won-loss record.

I have a column that contains either a "W" or an "L" in it.
Is there a way to select a range of cells and determine the number o
times "W" appears, separated by a hypen and then how many times "L
appears. Thus determing a won-loss record in the format (W-L) t
display at the bottom of that column.

Thank you for any help provided

 

[Frank Kabel]

Hi
if your range is A1:A100 try
=COUNTIF(A1:A100,"W") & " - " & COUNTIF(A1:A100,"L")

 

[bubba1965]

Thank you so much Frank.

I got it to work for my first cell range.

When I try to do if for the second range - it just returns my formul
and no result - what am I doing wrong

 

[Frank Kabel]

Hi
it does only return the formula text?
If yes what have you entered exactly (include the equation sign)

You may also check the cell format (goto 'Format - cells') If this is
set to 'Text' change it to 'General' and try again

 

[bubba1965]

I have several different sheets with the won-loss record. So I am jus
copying and pasting the formula into the cell I want the desired resul
and then I am adjusting the cell range, if it is different from th
previous.

My example that is returning just the formula is

=COUNTIF(E3:E40,"W") & " - " & COUNTIF(E3:E40,"L")

Thanks Fran

 

[Frank Kabel]

O.K.
then check the cell fomat

 

[bubba1965]

Thanks.
That worked grea