Calculating the average ("hitrate") of fotball results

[matchedbettingnorge]

<style><!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:" ";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr {mso-height-source:auto;}col {mso-width-source:auto;}br {mso-data-placement:same-cell;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {color:black; font-weight:700;}.xl64 {font-weight:700; background:yellow; mso-pattern:black none;}.xl65 {color:black; font-weight:700; background:yellow; mso-pattern:black none;}--></style>I want to find the average (or the "hit rate") of World Cup football results. I have calculated 2 points for correct 1X2, and 3 points for correct 1X2 and correct score. So the hit rate should be "yes" or "1" for 2 and 3 points and "no" or "0" for 0 points. I tried using the AVERAGEIFS, but get a DIV/0 error.

So, the result should be a % of the correct outcomes of the total games played, but not including the games not yet played in the average. In this case (after 10 games) the hit rate is 70%.

Probably not a difficult question, but I'd really appreciate the solution

1X2	Points	"Hit rate"
Home	2
Away	2
Draw	2
Away	3
Home	2
Away	0
Draw	0
Home	2
Draw	0
Away	3
Away	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0
Not Played	0

<!--StartFragment--> <colgroup><col width="87" span="3" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

 

[MARZIOTULLIO]

	A​	B​	C​
1​	1X2	Points	"Hit rate"
2​	Home	2​	70%​
3​	Away	2​
4​	Draw	2​
5​	Away	3​
6​	Home	2​
7​	Away	0​
8​	Draw	0​
9​	Home	2​
10​	Draw	0​
11​	Away	3​
12​	Away	0​
13​	Not Played	0​
14​	Not Played	0​
15​	Not Played	0​
16​	Not Played	0​
17​	Not Played	0​
18​	Not Played	0​
19​	Not Played	0​
20​	Not Played	0​
21​	Not Played	0​
22​	Not Played	0​
23​	Not Played	0​
24​	Not Played	0​
25​	Not Played	0​
26​	Not Played	0​
27​	Not Played	0​
28​	Not Played	0​
29​	Not Played	0​
30​	Not Played	0​
31​	Not Played	0​
32​	Not Played	0​
33​	Not Played	0​
34​	Not Played	0​
35​	Not Played	0​
36​	Not Played	0​
37​	Not Played	0​
38​	Not Played	0​
39​	Not Played	0​
40​	Not Played	0​
41​	Not Played	0​
42​	Not Played	0​
43​	Not Played	0​
44​	Not Played	0​
45​	Not Played	0​
46​	Not Played	0​
47​	Not Played	0​
48​	Not Played	0​
49​	Not Played	0​

<tbody>
</tbody>

c2=SUMPRODUCT(COUNTIF($B$2:$B$49,B4:B5))/10 format c2 as %

 

[matchedbettingnorge]

c2=SUMPRODUCT(COUNTIF($B$2:$B$49,B4:B5))/10 format c2 as %

Thanks! But I want to update C2 when the results of the upcoming games are played. If i /10, that would only calculate the hitrate for the first 10 games. I need the formula to calculate the average for B2:49, and excluding the cells where A="Not played".

 

[matchedbettingnorge]

c2=SUMPRODUCT(COUNTIF($B$2:$B$49,B4:B5))/10 format c2 as %

Thanks! Looks like my answer did get posted. I need the hit rate calculated after the matches are played. If I put /10 I only get the first 10 matches. I need a formula where I calculate the average for the matches played (only the cells with "Home", "Draw", and "Away". Excluding "Not played".) which automatically includes the played matches as they are played (When A13:49=Home/Draw/Away, it will be included in the average hitrate)

Thanks again!