View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Very simple question.

HI Fenneth,

=SUM(A1:A10)/COUNTA(A1:A10)

Format as %

--
Kind regards,

Niek Otten

"Fenneth" wrote in message
...
|
| I have made a spreadsheet to track my results in a certain game.
| Basically I just have a column in which I put 1 for a win and 0 for a
| loss. What formula should I use to determine my % of wins?
|
| Thanks in advance.
|
|
| --
| Fenneth
| ------------------------------------------------------------------------
| Fenneth's Profile: http://www.excelforum.com/member.php...o&userid=33655
| View this thread: http://www.excelforum.com/showthread...hreadid=534290
|