Spreadsheet: 799562d1665144827-averageifs-to-calculate-averages-within-groups-of-data-example1
Sheet: Hay Consumption

HAY CONSUMED
Group 1 | Treatment | Week 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13
 |  | Day 22 |  |  | Day 23 |  |  | Day 24 |  |  | Day 25 |  |  | Day 26 |  |  | Day 27 |  |  | Day 28 |  |  | Day 29 |  |  | Day 30 |  |  | Day 31 |  |  | Day 32 |  |  | Day 33 |  |  | Day 34 |  |  | Day 35 |  |  | Day 36 |  |  | Day 37 |  |  | Day 38 |  |  | Day 39 |  |  | Day 40 |  |  | Day 41 |  |  | Day 42 |  |  | Day 43 |  |  | Day 44 |  |  | Day 45 |  |  | Day 46 |  |  | Day 47 |  |  | Day 48 |  |  | Day 49 |  |  | Day 50 |  |  | Day 51 |  |  | Day 52 |  |  | Day 53 |  |  | Day 54 |  |  | Day 55 |  |  | Day 56 |  |  | Day 57 |  |  | Day 58 |  |  | Day 59 |  |  | Day 60 |  |  | Day 61 |  |  | Day 62 |  |  | Day 63 |  |  | Day 64 |  |  | Day 65 |  |  | Day 66 |  |  | Day 67 |  |  | Day 68 |  |  | Day 69 |  |  | Day 70 |  |  | Day 71 |  |  | Day 72 |  |  | Day 73 |  |  | Day 74 |  |  | Day 75 |  |  | Day 76 |  |  | Day 77 |  |  | Day 78 |  |  | Day 79 |  |  | Day 80 |  |  | Day 81 |  |  | Day 82 |  |  | Day 83 |  |  | Day 84 |  |  | Day 85 |  |  | Day 86 |  |  | Day 87 |  |  | Day 88 |  |  | Day 89 |  |  | Day 90 |  |  | Day 91
 |  | 2022-07-11 00:00:00
 |  | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed
603978 | Control
703979 | Treated
207434 | Treated
507437 | Control
103980 | Treated
203981 | Control
303982 | Treated
403983 | Control
Group 2 | Treatment | Week 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13
 |  | Day 22 |  |  | Day 23 |  |  | Day 24 |  |  | Day 25 |  |  | Day 26 |  |  | Day 27 |  |  | Day 28 |  |  | Day 29 |  |  | Day 30 |  |  | Day 31 |  |  | Day 32 |  |  | Day 33 |  |  | Day 34 |  |  | Day 35 |  |  | Day 36 |  |  | Day 37 |  |  | Day 38 |  |  | Day 39 |  |  | Day 40 |  |  | Day 41 |  |  | Day 42 |  |  | Day 43 |  |  | Day 44 |  |  | Day 45 |  |  | Day 46 |  |  | Day 47 |  |  | Day 48 |  |  | Day 49 |  |  | Day 50 |  |  | Day 51 |  |  | Day 52 |  |  | Day 53 |  |  | Day 54 |  |  | Day 55 |  |  | Day 56 |  |  | Day 57 |  |  | Day 58 |  |  | Day 59 |  |  | Day 60 |  |  | Day 61 |  |  | Day 62 |  |  | Day 63 |  |  | Day 64 |  |  | Day 65 |  |  | Day 66 |  |  | Day 67 |  |  | Day 68 |  |  | Day 69 |  |  | Day 70 |  |  | Day 71 |  |  | Day 72 |  |  | Day 73 |  |  | Day 74 |  |  | Day 75 |  |  | Day 76 |  |  | Day 77 |  |  | Day 78 |  |  | Day 79 |  |  | Day 80 |  |  | Day 81 |  |  | Day 82 |  |  | Day 83 |  |  | Day 84 |  |  | Day 85 |  |  | Day 86 |  |  | Day 87 |  |  | Day 88 |  |  | Day 89 |  |  | Day 90 |  |  | Day 91
 |  | 2022-07-18 00:00:00
 |  | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed
503984 | Treated
603985 | Control
707439 | Control
307442 | Treated
207441 | Control
407443 | Treated
703986 | Control
203988 | Treated
Group 3 | Treatment | Week 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13
 |  | Day 22 |  |  | Day 23 |  |  | Day 24 |  |  | Day 25 |  |  | Day 26 |  |  | Day 27 |  |  | Day 28 |  |  | Day 29 |  |  | Day 30 |  |  | Day 31 |  |  | Day 32 |  |  | Day 33 |  |  | Day 34 |  |  | Day 35 |  |  | Day 36 |  |  | Day 37 |  |  | Day 38 |  |  | Day 39 |  |  | Day 40 |  |  | Day 41 |  |  | Day 42 |  |  | Day 43 |  |  | Day 44 |  |  | Day 45 |  |  | Day 46 |  |  | Day 47 |  |  | Day 48 |  |  | Day 49 |  |  | Day 50 |  |  | Day 51 |  |  | Day 52 |  |  | Day 53 |  |  | Day 54 |  |  | Day 55 |  |  | Day 56 |  |  | Day 57 |  |  | Day 58 |  |  | Day 59 |  |  | Day 60 |  |  | Day 61 |  |  | Day 62 |  |  | Day 63 |  |  | Day 64 |  |  | Day 65 |  |  | Day 66 |  |  | Day 67 |  |  | Day 68 |  |  | Day 69 |  |  | Day 70 |  |  | Day 71 |  |  | Day 72 |  |  | Day 73 |  |  | Day 74 |  |  | Day 75 |  |  | Day 76 |  |  | Day 77 |  |  | Day 78 |  |  | Day 79 |  |  | Day 80 |  |  | Day 81 |  |  | Day 82 |  |  | Day 83 |  |  | Day 84 |  |  | Day 85 |  |  | Day 86 |  |  | Day 87 |  |  | Day 88 |  |  | Day 89 |  |  | Day 90 |  |  | Day 91
 |  | 2022-07-25 00:00:00
 |  | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed
504019 | Control | 0.1 | 0.05
604020 | Treated | 0.1 | 0.1
704021 | Control | 0.1 | 0.05
304024 | Treated | 0.1 | 0.1
104022 | Control | 0.1 | 0.1
204023 | Treated
404025 | Treated | 0.1 | 0.04
504026 | Control | 0.1 | 0.07
 | Treatment | Week 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13
Group 4 |  | Day 22 |  |  | Day 23 |  |  | Day 24 |  |  | Day 25 |  |  | Day 26 |  |  | Day 27 |  |  | Day 28 |  |  | Day 29 |  |  | Day 30 |  |  | Day 31 |  |  | Day 32 |  |  | Day 33 |  |  | Day 34 |  |  | Day 35 |  |  | Day 36 |  |  | Day 37 |  |  | Day 38 |  |  | Day 39 |  |  | Day 40 |  |  | Day 41 |  |  | Day 42 |  |  | Day 43 |  |  | Day 44 |  |  | Day 45 |  |  | Day 46 |  |  | Day 47 |  |  | Day 48 |  |  | Day 49 |  |  | Day 50 |  |  | Day 51 |  |  | Day 52 |  |  | Day 53 |  |  | Day 54 |  |  | Day 55 |  |  | Day 56 |  |  | Day 57 |  |  | Day 58 |  |  | Day 59 |  |  | Day 60 |  |  | Day 61 |  |  | Day 62 |  |  | Day 63 |  |  | Day 64 |  |  | Day 65 |  |  | Day 66 |  |  | Day 67 |  |  | Day 68 |  |  | Day 69 |  |  | Day 70 |  |  | Day 71 |  |  | Day 72 |  |  | Day 73 |  |  | Day 74 |  |  | Day 75 |  |  | Day 76 |  |  | Day 77 |  |  | Day 78 |  |  | Day 79 |  |  | Day 80 |  |  | Day 81 |  |  | Day 82 |  |  | Day 83 |  |  | Day 84 |  |  | Day 85 |  |  | Day 86 |  |  | Day 87 |  |  | Day 88 |  |  | Day 89 |  |  | Day 90 |  |  | Day 91
 |  | 2022-08-01 00:00:00
 |  | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed | Offered | Refused | Consumed
507507 | Control
107510 | Treated
604027 | Treated
704028 | Control
104029 | Treated
204030 | Control
304031 | Treated
404032 | Control
 | CONTROL
AVERAGE | Treated