Hi,

I'm doing a betting spreadsheet and I want to work out how my success rate in a percentage. At the moment I have a column which indicates a win (with the figure 0) or a loss (with the figure 1). How do I calculate the percentage of times that I win?

I'd also like it to keep updating without me having to select more and more cells the more betting i do, is there a way of doing this?

I appreciate any help,
Alex