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

=sum(yourrange)/count(yourrange)

format as a percentage

Fenneth wrote:

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

--

Dave Peterson

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
|

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

"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