[SOLVED] excel / spreadsheet question

brannsiu

Distinguished
Apr 20, 2013
1,064
3
19,285
Hi.
I'll have a list of columns or rows where they will only have three possible assigned value, assigned by me
e.g. W, L or D

W=Win
L=Lose
D=Draw

I'd like to have a cell that would calculate the winning rate, i.e. number of cells that contain W / total number of cells (not including Draw)

How can I make this? I'm new to excel and spreedsheet things.....