Very simple question.

F

Fenneth

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.
 
N

Niek Otten

HI Fenneth,

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

Format as %

--
Kind regards,

Niek Otten

|
| 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?action=getinfo&userid=33655
| View this thread: http://www.excelforum.com/showthread.php?threadid=534290
|
 
D

Don Guillett

Simple if you know how. Pls use meaningful subject lines.
=AVERAGE(IF(G1:G5>0,G1:G5))
This is an ARRAY formula so must be entered edited using ctrl+shift+enter vs
just enter.
 
Top