Percentage Count Formula Needed

[olimajor123]

Hi.

I have a spreadsheet which tracks football predictions with a score being allocated to each game depending on whether or not the predicted result was correct. If the resulted predicted is incorrect, the cell says 0, whereas if it is correct is has a number of points won in it (which varies). I am looking for a formula to work out the percentage of matches where points for correct guesses have been scored, ie I need it to count the number of matches and count the number of games that aren't zero and divide it by the total number of matches (both where points were scored and where no points were scored). Please can you help.

 

[Lligtrah]

If I'm reading your question correctly, you want to use =COUNT and =COUNTIF

So, to calculate the number of matches played: =COUNT([Score Column]). This will look down the score column and only count cells with numbers in them, ignoring blanks and text cells.

For the number of correct predictions: =COUNTIF([Predictions Column],">0"). This will look down the predictions column and only count values over 0. Again, this ignores blanks and text.


For the percentage of predictions correct roll them all into one formula:

=COUNT([Score Column])/COUNTIF([Prediction Column},">0").

 

[olimajor123]

Thanks. I had to swap them around so I had =COUNTIF(R13:R122,">0")/COUNT(R13:R122) but then it worked. Cheers

 

[Lligtrah]

Silly mistake, my apologies!