Spreadsheet: 881258d1729253364-computing-an-average-with-multiple-criteria-tlillys-book1
Sheet: Sheet1

Year | Month | No leap | Leap |  |  | Average |  |  |  | Year | (All)
1 | Januari | 2.29 | 2.29 |  | Januari
1 | februari | 4.89 | 4.89 |  | februari |  |  |  |  | Row Labels | Average of Leap | Average of No leap
1 | Maart | 3.05 | 3.41 |  | Maart |  |  |  |  | Januari | 3.89125 | 3.89125
1 | April | 2.17 | 1.81 |  | April |  |  |  |  | februari | 5.3825 | 5.09875
1 | [NAME] | 3.41 | 3.41 |  | [NAME] |  |  |  |  | Maart | 4.6425 | 4.766249999999999
1 | Juni | 4.529999999999999 | 4.529999999999999 |  | Juni |  |  |  |  | April | 4.34625 | 4.2475
1 | [NAME] | 3.63 | 3.92 |  | [NAME] |  |  |  |  | [NAME] | 4.915000000000001 | 4.930000000000001
1 | Augustus | 4.38 | 4.09 |  | Augustus |  |  |  |  | Juni | 4.0125 | 4.105
1 | September | 4.7 | 4.7 |  | September |  |  |  |  | [NAME] | 5.40375 | 5.368749999999999
1 | Oktober | 2.64 | 2.64 |  | Oktober |  |  |  |  | Augustus | 3.16625 | 3.3525
1 | November | 3.56 | 3.56 |  | November |  |  |  |  | September | 4.90625 | 4.86625
1 | December | 9.280000000000001 | 9.280000000000001 |  | December |  |  |  |  | Oktober | 2.39375 | 2.3425
2 | Januari | 2.55 | 2.55 |  |  |  |  |  |  | November | 2.975 | 2.72875
2 | februari | 5.210000000000001 | 5.440000000000001 |  |  |  |  |  |  | December | 5.365 | 5.6525
2 | Maart | 5.62 | 5.39 |  |  |  |  |  |  | Grand Total | 4.283333333333332 | 4.279166666666668
2 | April | 8.229999999999999 | 10.3
2 | [NAME] | 7.529999999999999 | 5.460000000000001
2 | Juni | 3.26 | 3.26
2 | [NAME] | 6.93 | 6.93
2 | Augustus | 0.74 | 0.74
2 | September | 8.16 | 8.16
2 | Oktober | 1.22 | 1.35
2 | November | 1.73 | 1.6
2 | December | 7.14 | 7.14
3 | Januari | 6.02 | 6.02
3 | februari | 7.739999999999999 | 7.739999999999999
3 | Maart | 2.36 | 2.36
3 | April | 2.13 | 2.13
3 | [NAME] | 13.02 | 14.65
3 | Juni | 7.649999999999999 | 6.720000000000001
3 | [NAME] | 7.639999999999999 | 7.84
3 | Augustus | 2.17 | 1.27
3 | September | 5.869999999999999 | 5.869999999999999
3 | Oktober | 1.17 | 1.33
3 | November | 3.400000000000001 | 3.240000000000001
3 | December | 3.54 | 3.54
4 | Januari | 3.91 | 3.91
4 | februari | 4.149999999999999 | 4.629999999999999
4 | Maart | 5.619999999999999 | 5.819999999999999
4 | April | 4.54 | 3.86
4 | [NAME] | 2.51 | 2.51
4 | Juni | 2.75 | 2.75
4 | [NAME] | 4.36 | 4.36
4 | Augustus | 4 | 4
4 | September | 4.069999999999999 | 4.39
4 | Oktober | 3.23 | 2.91
4 | November | 1.44 | 1.44
4 | December | 1.59 | 1.68
5 | Januari | 8.75 | 8.75
5 | februari | 6.05 | 6.05
5 | Maart | 3.21 | 3.21
5 | April | 6.049999999999999 | 6.049999999999999
5 | [NAME] | 2.72 | 3.04
5 | Juni | 5.02 | 4.7
5 | [NAME] | 4.91 | 5.04
5 | Augustus | 4.26 | 4.13
5 | September | 4.609999999999999 | 4.609999999999999
5 | Oktober | 2.3 | 2.3
5 | November | 3.64 | 3.79
5 | December | 3.22 | 3.37
6 | Januari | 2.7 | 2.7
6 | februari | 2.66 | 3.6
6 | Maart | 6.259999999999999 | 5.319999999999999
6 | April | 3.31 | 3.31
6 | [NAME] | 7.38 | 7.38
6 | Juni | 4.13 | 4.13
6 | [NAME] | 6.65 | 6.82
6 | Augustus | 3.62 | 3.45
6 | September | 3.75 | 3.75
6 | Oktober | 3.26 | 3.26
6 | November | 1.07 | 1.36
6 | December | 6.54 | 6.26
7 | Januari | 0.52 | 0.52
7 | februari | 7.27 | 7.51
7 | Maart | 4.27 | 4.029999999999999
7 | April | 3.57 | 3.57
7 | [NAME] | 0.49 | 0.49
7 | Juni | 1.96 | 1.96
7 | [NAME] | 5.79 | 5.79
7 | Augustus | 3.37 | 3.37
7 | September | 4.25 | 4.25
7 | Oktober | 3.36 | 3.8
7 | November | 3.92 | 4.94
7 | December | 5.36 | 3.9
8 | Januari | 4.39 | 4.39
8 | februari | 2.82 | 3.2
8 | Maart | 7.740000000000001 | 7.600000000000001
8 | April | 3.98 | 3.74
8 | [NAME] | 2.38 | 2.38
8 | Juni | 3.54 | 4.05
8 | [NAME] | 3.04 | 2.529999999999999
8 | Augustus | 4.279999999999999 | 4.279999999999999
8 | September | 3.52 | 3.52
8 | Oktober | 1.56 | 1.56
8 | November | 3.07 | 3.87
8 | December | 8.549999999999999 | 7.749999999999999