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