Spreadsheet: 766198d1643795931-sumproduct-with-criteria-month-and-year-error-when-having-grand-totals-book3
Sheet: RESULTS

 |  |  |  | [NAME] | 1 | 2022
Referrals
Local Office | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 | 2021-03-08 00:00:00 | 2021-03-15 00:00:00 | 2021-03-22 00:00:00 | 2021-03-29 00:00:00 | 2021-04-05 00:00:00 | 2021-04-12 00:00:00 | 2021-04-19 00:00:00 | 2021-04-26 00:00:00 | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00 | 2021-07-26 00:00:00 | 2021-08-02 00:00:00 | 2021-08-09 00:00:00 | 2021-08-16 00:00:00 | 2021-08-23 00:00:00 | 2021-08-30 00:00:00 | 2021-09-06 00:00:00 | 2021-09-13 00:00:00 | 2021-09-20 00:00:00 | 2021-09-27 00:00:00 | 2021-10-04 00:00:00 | 2021-10-11 00:00:00 | 2021-10-18 00:00:00 | 2021-10-25 00:00:00 | 2021-11-01 00:00:00 | 2021-11-08 00:00:00 | 2021-11-15 00:00:00 | 2021-11-22 00:00:00 | 2021-11-29 00:00:00 | 2021-12-06 00:00:00 | 2021-12-13 00:00:00 | 2021-12-20 00:00:00 | 2021-12-27 00:00:00 | 2022-01-03 00:00:00 | 2022-01-10 00:00:00 | 2022-01-17 00:00:00 | 2022-01-24 00:00:00 | grand total
ACTON |  |  | 78 | 58 | 115 | 34 | 20 | 21 | 25 | 21 | 22 | 17 | 1 | 18 | 13 | 28 | 30 | 47 | 33 | 19 | 12 | 28 | 11 | 14 | 11 | 20 | 9 | 8 | 12 | 50 | 17 | 24 | 23 | 20 | 11 | 19 | 22 | 26 | 24 | 16 | 12 | 6 | 15 | 6 | 7 | 3 | 11 | 5 | 16 | 15 | 14 | 11 | 8 | 14 | 6 | 8 | 21 | 9 | 12 | 18 | 13 | 10 | 7 | 8 |  | 3 | 7 | 6 | 29
EALING |  |  | 59 | 56 | 75 | 58 | 38 | 36 | 42 | 24 | 34 | 9 | 7 | 46 | 61 | 60 | 93 | 79 | 97 | 93 | 68 | 66 | 27 | 28 | 17 | 29 | 18 | 95 | 121 | 90 | 88 | 84 | 67 | 79 | 66 | 67 | 62 | 58 | 45 | 56 | 51 | 32 | 37 | 21 | 19 | 37 | 34 | 15 | 28 | 22 | 32 | 33 | 40 | 30 | 25 | 11 | 21 | 29 | 36 | 34 | 44 | 32 | 32 | 31 | 7 | 11 | 38 | 74 | 46
FULHAM |  |  | 72 | 42 | 24 | 11 | 20 | 21 | 10 | 14 | 7 | 1 | 4 | 13 | 13 | 15 | 29 | 27 | 27 | 15 | 20 | 14 | 12 | 16 | 8 | 2 | 6 | 3 | 13 | 20 | 28 | 40 | 24 | 20 | 12 | 33 | 31 | 15 | 11 | 16 | 16 | 17 | 14 | 17 | 21 | 18 | 27 | 6 | 13 | 10 | 4 | 2 | 2 | 11 | 11 | 8 | 8 | 6 | 10 | 10 | 12 | 8 | 7 | 12 |  | 9 | 15 | 9 | 11
HARLESDEN |  |  | 30 | 33 | 35 | 47 | 68 | 36 | 2 | 17 | 35 | 8 | 3 | 25 | 28 | 15 | 11 | 20 | 7 | 4 | 24 | 28 | 11 | 19 | 9 | 16 | 9 | 10 | 31 | 26 | 22 | 34 | 29 | 21 | 10 | 34 | 37 | 31 | 57 | 74 | 83 | 44 | 35 | 30 | 27 | 21 | 29 | 10 | 22 | 33 | 31 | 13 | 20 | 26 | 44 | 47 | 44 | 54 | 50 | 48 | 42 | 40 | 36 | 41 | 7 | 25 | 63 | 52 | 57
HARROW |  |  | 56 | 85 | 71 | 51 | 51 | 45 | 9 | 10 | 6 | 7 |  | 8 | 14 | 33 | 20 | 17 | 26 | 20 | 21 | 20 | 11 | 19 | 18 | 15 | 10 | 7 | 35 | 48 | 44 | 49 | 33 | 40 | 15 | 37 | 37 | 36 | 23 | 20 | 32 | 12 | 28 | 10 | 16 | 21 | 25 | 10 | 31 | 21 | 22 | 23 | 12 | 16 | 25 | 21 | 32 | 31 | 25 | 29 | 36 | 45 | 32 | 18 | 5 | 17 | 30 | 24 | 19
HAYES |  |  | 55 | 55 | 89 | 65 | 70 | 28 | 5 | 16 | 11 | 2 | 2 | 7 | 15 | 10 | 10 | 13 | 12 | 9 | 12 | 13 | 8 | 11 | 8 | 6 | 6 | 5 | 10 | 6 | 15 | 16 | 25 | 15 | 8 | 10 | 18 | 16 | 12 | 13 | 4 | 9 | 6 | 2 | 7 | 1 | 3 | 3 | 3 | 3 | 6 | 11 | 1 | 15 | 6 | 5 | 3 |  | 21 | 12 | 4 | 21 | 7 | 9 | 1 | 4 | 5 | 10 | 25
HOUNSLOW |  |  | 69 | 69 | 57 | 36 | 50 | 54 | 52 | 31 | 25 | 6 | 12 | 34 | 31 | 36 | 27 | 32 | 40 | 36 | 36 | 33 | 52 | 47 | 35 | 26 | 12 | 23 | 26 | 30 | 26 | 46 | 37 | 30 | 28 | 42 | 29 | 34 | 48 | 65 | 52 | 39 | 38 | 33 | 49 | 33 | 45 | 15 | 57 | 53 | 26 | 24 | 14 | 25 | 24 | 10 | 13 | 43 | 30 | 47 | 28 | 24 | 35 | 19 | 8 | 25 | 47 | 36 | 26
KINGSTON | 14 | 12 | 21 | 27 | 43 | 31 | 25 | 21 | 14 | 26 | 27 | 8 | 12 | 14 | 31 | 24 | 24 | 25 | 33 | 23 | 27 | 17 | 18 | 29 | 25 | 18 | 6 | 22 | 22 | 17 | 19 | 13 | 18 | 25 | 26 | 27 | 25 | 28 | 28 | 19 | 22 | 22 | 21 | 17 | 11 | 9 | 6 | 17 | 11 | 8 | 14 | 8 | 7 | 13 | 14 | 11 | 21 | 14 | 20 | 13 | 20 | 15 | 6 | 2 |  | 3 | 12 | 19 | 16
SHEPHERDS BUSH |  |  | 13 | 53 | 119 | 48 | 27 | 41 | 4 | 12 | 10 | 8 | 8 | 10 | 3 | 12 | 12 | 16 | 12 | 8 | 10 | 12 | 7 | 8 | 5 |  | 3 | 23 | 39 | 28 | 29 | 20 | 17 | 16 | 19 | 29 | 21 | 21 | 16 | 22 | 28 | 12 | 11 | 10 | 20 | 18 | 6 | 4 | 6 | 5 | 1 | 2 | 2 | 1 | 3 | 2 | 9 | 6 | 13 | 7 | 7 | 5 |  | 1 |  | 2 | 1 | 5 | 10
TWICKENHAM | 14 | 11 |  |  | 26 | 52 | 61 | 50 | 17 | 19 | 34 | 11 | 3 | 35 | 26 | 26 | 19 | 14 | 20 | 24 | 25 | 32 | 22 | 30 | 25 | 21 | 10 | 25 | 26 | 18 | 14 | 24 | 22 | 11 | 9 | 21 | 13 | 12 | 16 | 20 | 12 | 5 | 8 | 14 | 8 | 13 | 15 | 6 | 8 | 1 | 8 | 8 | 2 | 6 | 15 | 9 | 12 | 21 | 16 | 20 |  | 12 | 17 | 1 | 2 | 6 | 12 | 12 | 7
UXBRIDGE |  |  | 60 | 30 | 75 | 57 | 35 | 23 | 5 | 10 | 16 | 7 |  | 9 | 27 | 8 | 2 | 1 | 7 | 14 | 21 | 7 | 18 | 5 | 16 | 11 | 5 | 5 | 10 | 11 | 21 | 19 | 5 | 15 | 7 | 16 | 15 | 22 | 27 | 18 | 14 | 10 | 8 | 4 | 8 | 14 | 18 | 9 | 13 | 7 | 26 | 12 | 22 | 10 | 6 | 10 | 3 | 7 | 17 | 25 | 21 | 27 | 14 | 18 | 3 | 7 | 12 | 18 | 14
WANDSWORTH |  |  | 45 | 26 | 25 | 12 | 22 | 19 | 12 | 19 | 16 | 17 | 9 | 19 | 17 | 17 | 32 | 27 | 17 | 8 | 17 | 6 | 8 | 13 | 11 | 8 | 5 | 8 | 16 | 15 | 28 | 29 | 28 | 21 | 9 | 18 | 30 | 11 | 9 | 26 | 18 | 13 | 11 | 9 | 19 | 13 | 15 | 11 | 10 | 10 | 9 | 6 | 14 | 10 | 8 | 7 | 9 | 7 | 12 | 4 | 9 | 3 | 2 | 4 | 2 | 8 | 18 | 34 | 20
WEMBLEY |  |  | 78 | 82 | 99 | 104 | 96 | 90 | 60 | 66 | 52 | 23 | 17 | 38 | 48 | 57 | 48 | 46 | 49 | 24 | 63 | 60 | 50 | 21 | 40 | 37 | 26 | 24 | 35 | 30 | 13 | 14 | 15 | 19 | 27 | 28 | 21 | 51 | 26 | 32 | 33 | 18 | 21 | 17 | 12 | 7 | 9 | 17 | 21 | 12 | 8 | 11 | 4 | 10 | 5 | 3 | 7 | 5 | 28 | 64 | 32 | 24 | 15 | 16 | 2 | 3 | 23 | 10 | 8
Grand Total | 28 | 23 | 636 | 616 | 853 | 606 | 583 | 485 | 257 | 285 | 295 | 124 | 78 | 276 | 327 | 341 | 357 | 364 | 380 | 297 | 356 | 336 | 255 | 260 | 228 | 209 | 125 | 258 | 396 | 389 | 364 | 412 | 343 | 332 | 247 | 381 | 361 | 361 | 342 | 397 | 377 | 239 | 253 | 190 | 224 | 208 | 243 | 128 | 239 | 200 | 201 | 164 | 148 | 187 | 192 | 152 | 203 | 232 | 290 | 331 | 268 | 266 | 210 | 180 | 37 | 123 | 283 | 309 | 288