using excel to calculate win-loss records

[Guest]

If i have an excel spreadsheet detailing my sports program's win-loss
records, i have a column titled "W/L"...and a "W" if they win and an "L" if
they lose. Is there a formula that would total the amount of "W"'s and "L"'s
and display it in a traditional Win-Loss format? (ie Wins-Losses, or for
example 3-14)

Any help would be appreciated.

 

[duane]

if your W or L range is c5:c11 this should work

=CONCATENATE(COUNTIF($C$5:$C$11,"W"),"-",COUNTIF($C$5:$C$11,"L")

 

[BenjieLop]

Assume

"W" is in A2:A100
"L" is in B2:B100

Enter in Cell A101: =sum(A2:A100)
Enter in Cell B101: =sum(B2:B100)

The "Wins-Losses" cell formula (as you want it formatted) is

=A101&"-"&B101

Hope this is OK with you.

 

[Biff]

Hi!

=COUNTIF(A1:A50,"W")&"-"&COUNTIF(A1:A50,"L")

Biff