Wins converted to”1” won’t sum

**alan_stephen75@** · 10-03-2010, 10:39 AM

I am attempting to create a sports scoring system in Excel 2003 to reflect the following. Col B will have a list of 10 country names, Col C will show either a W for a win, L for a loss with both Cols blank before any data is entered prior to the start of the competition.

I would then like to transfer these individual wins (W) or (L) to a grid below converted to a 1or 0 so that I can finally add them up to establish a winner.

This formula is used to place one of the 10 teams Wins/Losses in a cell below =IF(B8="","",IF(C8="",B9,IF(C8="W","1",IF(C8="L","0"))))
and that seems to work fine and gives me a blank, a country name or a 1/0

I then use the following formula to show a running total of that countries 10 scores =IF(COUNTBLANK(F24:O24)=10,"",SUM(F24:O24))
But this is where the problem arises in that it won’t add up and returns a 0 and it doesn’t seem to recognise that the “W” is a “1” so can anyone help me with this latter formula?

I hope I have given sufficient info to enable a solution. Thank you for any help you can give me. .

**royUK** · 10-03-2010, 10:48 AM

By using "1" instead of 1 they are being converted to Text not numbers

**MarvinP** · 10-03-2010, 10:54 AM

You don't have to convert the wins and losses to numbers to count them. You can use the CountIf formula.

For wins "=Countif(Range,"=W") do an L for losses.