Need more help on Excel

[Roshan]

I am trying to get ready for football season by setting up a excel spreadsheet in which I setup my picks for the week. Basically what the spreadsheet does is it reades whether the pick that I make matches with the actula result of the game. If it does then a "Win" will be posted in column D. If the two entries don't match then a "Loss" will be put in column E. What I am trying to do is at the bottom of each week calculate how many cells say Win and how many cells say Loss, so the spreadsheet will automatically calculate the record for me. Does anybody know how to do this. If this is too confusing please send put your e-mail address and I will send an attachment of the file and further explain. Thank You very much.

 

[HermDogg]

Use 1s and 0s. 1=win 0=loss. Life becomes easier.

 

[Concillian]

Built in function in Excel for it:
COUNTIF(Range,Criteria)

=COUNTIF(D,"Win")
=COUNTIF(E:E,"Loss")

To bulletproof it for moving the cells around, I'd make it:
=COUNTIF($D:$D,"Win")

Why do you have the Wins and Losses in separate columns? Why not make it all in one column?