How to add up Win/Loss/Tie Records in Excel

[mgd0011]

I have an excel spreadsheet with a column for each game saying "Win" "Loss" or "Tie"

what can i do so that the record automatically updates the W-L-Tie cell when I enter in the result of the game.

Also, I have this for multiple sports so how can I get one cell to add all the total W-L-T records into one big record?

 

[Michael M]

make small summary table and use a countif formula for each result, eg..
If the Win/loss/tie is in col "C" you could use

=countif(C:C,"Win")

and it would update as the results change for "Win"

 

[JohnGSnyder01]

This formula should work if C3:C38 contains W-L-T data.

=COUNTIF(C3:C38,"Win")&"-"&COUNTIF(C3:C38,"loss")&"-"&COUNTIF(C3:C38,"tie")