Spreadsheet: 744657d1629369065-how-can-i-get-averages-for-multiple-ranges-sugar-forum
Sheet: Export

Date | mmol /L | Time | Rolling Average | Before breakfast | After breakfast | Before lunch | After lunch | Before tea | Before breakfast | Bed
 |  |  |  |  |  |  |  |  |  |  | Average since day 1
 |  |  |  |  |  |  |  |  |  |  | Average for the last ? days |  |  |  | 7
2021-08-01 00:00:00 | 7.9 | Before breakfast
2021-08-01 00:00:00 | 9.2 | After breakfast
2021-08-01 00:00:00 | 8.4 | Before lunch
2021-08-01 00:00:00 | 10 | After lunch
2021-08-01 00:00:00 | 8.2 | Before tea
2021-08-01 00:00:00 | 9 | After tea
2021-08-01 00:00:00 | 8.5 | Bed
2021-08-02 00:00:00 | 8.4 | Before breakfast
2021-08-02 00:00:00 | 10 | After breakfast
2021-08-02 00:00:00 | 8.9 | Before lunch
2021-08-02 00:00:00 | 10.8 | After lunch
2021-08-02 00:00:00 | 9 | Before tea
2021-08-02 00:00:00 | 9.9 | After tea
2021-08-02 00:00:00 | 9 | Bed
2021-08-03 00:00:00 | 10.8 | Before breakfast
2021-08-03 00:00:00 | 10.4 | After breakfast
2021-08-03 00:00:00 | 8.7 | Before lunch
2021-08-03 00:00:00 | 8.4 | After lunch
2021-08-03 00:00:00 | 6.7 | Before tea
2021-08-03 00:00:00 | 12.3 | After tea
2021-08-03 00:00:00 | 11 | Bed
2021-08-04 00:00:00 | 9.9 | Before breakfast
2021-08-04 00:00:00 | 11.8 | After breakfast
2021-08-04 00:00:00 | 10.2 | Before lunch
2021-08-04 00:00:00 | 10.4 | After lunch
2021-08-04 00:00:00 | 9 | Before tea
2021-08-04 00:00:00 | 9.8 | After tea
2021-08-04 00:00:00 | 9 | Bed
2021-08-05 00:00:00 | 11.8 | Before breakfast
2021-08-05 00:00:00 | 10.6 | After breakfast
2021-08-05 00:00:00 | 8.5 | Before lunch
2021-08-05 00:00:00 | 9.3 | After lunch
2021-08-05 00:00:00 | 8.6 | Before tea
2021-08-05 00:00:00 | 9.2 | After tea
2021-08-05 00:00:00 | 8.9 | Bed
2021-08-06 00:00:00 | 10.4 | Before breakfast
2021-08-06 00:00:00 | 10.9 | After breakfast
2021-08-06 00:00:00 | 9.7 | Before lunch
2021-08-06 00:00:00 | 10.4 | After lunch
2021-08-06 00:00:00 | 8.4 | Before tea
2021-08-06 00:00:00 | 9.1 | After tea
2021-08-06 00:00:00 | 8.4 | Bed
2021-08-07 00:00:00 | 9.2 | Before breakfast
2021-08-07 00:00:00 | 10.4 | After breakfast
2021-08-07 00:00:00 | 8.3 | Before lunch
2021-08-07 00:00:00 | 8.9 | After lunch
2021-08-07 00:00:00 | 8.8 | Before tea
2021-08-07 00:00:00 | 9 | After tea
2021-08-07 00:00:00 | 8.2 | Bed
2021-08-08 00:00:00 | 10.4 | Before breakfast
2021-08-08 00:00:00 | 10.9 | After breakfast
2021-08-08 00:00:00 | 8.7 | Before lunch
2021-08-08 00:00:00 | 9 | After lunch
2021-08-08 00:00:00 | 7.9 | Before tea
2021-08-08 00:00:00 | 10.2 | After tea
2021-08-08 00:00:00 | 9 | Bed
2021-08-09 00:00:00 | 9.9 | Before breakfast
2021-08-09 00:00:00 | 10.7 | After breakfast
2021-08-09 00:00:00 | 8.5 | Before lunch
2021-08-09 00:00:00 | 9.5 | After lunch
2021-08-09 00:00:00 | 8.4 | Before tea
2021-08-09 00:00:00 | 8.9 | After tea
2021-08-09 00:00:00 | 7.4 | Bed
2021-08-10 00:00:00 | 10.6 | Before breakfast
2021-08-10 00:00:00 | 10 | After breakfast
2021-08-10 00:00:00 | 8.9 | Before lunch
2021-08-10 00:00:00 | 9 | After lunch
2021-08-10 00:00:00 | 9.2 | Before tea
2021-08-10 00:00:00 | 9.4 | After tea
2021-08-10 00:00:00 | 8.2 | Bed
2021-08-11 00:00:00 | 9.8 | Before breakfast
2021-08-11 00:00:00 | 10.4 | After breakfast
2021-08-11 00:00:00 | 9.8 | Before lunch
2021-08-11 00:00:00 | 9.9 | After lunch
2021-08-11 00:00:00 | 7.9 | Before tea
2021-08-11 00:00:00 | 8.1 | After tea
2021-08-11 00:00:00 | 8.4 | Bed
2021-08-12 00:00:00 | 8.9 | Before breakfast
2021-08-12 00:00:00 | 9.4 | After breakfast
2021-08-12 00:00:00 | 8.8 | Before lunch
2021-08-12 00:00:00 | 9 | After lunch
2021-08-12 00:00:00 | 8.1 | Before tea
2021-08-12 00:00:00 | 9.8 | After tea
2021-08-12 00:00:00 | 9.6 | Bed
2021-08-13 00:00:00 | 10.4 | Before breakfast
2021-08-13 00:00:00 | 10.8 | After breakfast
2021-08-13 00:00:00 | 7.9 | Before lunch
2021-08-13 00:00:00 | 8.4 | After lunch
2021-08-13 00:00:00 | 7.6 | Before tea
2021-08-13 00:00:00 | 8.9 | After tea
2021-08-13 00:00:00 | 8.4 | Bed
2021-08-14 00:00:00 | 9.8 | Before breakfast
2021-08-14 00:00:00 | 10.4 | After breakfast
2021-08-14 00:00:00 | 8.4 | Before lunch
2021-08-14 00:00:00 | 8.9 | After lunch
2021-08-14 00:00:00 | 7.8 | Before tea
2021-08-14 00:00:00 | 9 | After tea
2021-08-14 00:00:00 | 8.4 | Bed
2021-08-15 00:00:00 | 11 | Before breakfast
2021-08-15 00:00:00 | 11.8 | After breakfast
2021-08-15 00:00:00 | 9 | Before lunch
2021-08-15 00:00:00 | 9.1 | After lunch
2021-08-15 00:00:00 | 8 | Before tea
2021-08-15 00:00:00 | 9 | After tea
2021-08-15 00:00:00 | 8.3 | Bed
2021-08-16 00:00:00 | 10.4 | Before breakfast
2021-08-16 00:00:00 | 10.9 | After breakfast
2021-08-16 00:00:00 | 8 | Before lunch
2021-08-16 00:00:00 | 9.1 | After lunch
2021-08-16 00:00:00 | 9 | Before tea
2021-08-16 00:00:00 | 9 | After tea
2021-08-16 00:00:00 | 8.2 | Bed
2021-08-17 00:00:00 | 9.8 | Before breakfast
2021-08-17 00:00:00 | 10.4 | After breakfast
2021-08-17 00:00:00 | 8.9 | Before lunch
2021-08-17 00:00:00 | 9.4 | After lunch
2021-08-17 00:00:00 | 8.9 | Before tea
2021-08-17 00:00:00 | 9.6 | After tea
2021-08-17 00:00:00 | 9.1 | Bed
 | 10.4 | Before breakfast
 | 11 | After breakfast
 | 9 | Before lunch
 | 9.2 | After lunch
 | 7.6 | Before tea
 | 8.9 | After tea
 | 7.8 | Bed
 |  | Before breakfast
 |  | After breakfast
 |  | Before lunch
 |  | After lunch
 |  | Before tea
 |  | After tea
 |  | Bed
 |  | Before breakfast
 |  | After breakfast
 |  | Before lunch
 |  | After lunch
 |  | Before tea
 |  | After tea
 |  | Bed