Spreadsheet: 781005d1652939266-formula-to-sum-a-table-range-and-return-value-with-vertical-and-horizontal-criteria-bookings-index-match-match-aligw
Sheet: New Bookings

 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Dainel M. | [NAME] | [NAME] | [NAME] | Eloise F. | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Dates | Year | Month2 | Date | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Caneeda Henry | [NAME] | Dainel Mitchell | [NAME] | [NAME] | [NAME] | Eloise [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | 2022 | 1 | 3 |  |  |  |  |  |  |  | 5 |  | 5 |  |  |  | 10 | 7 | 2 |  |  | 13 | 8 |  |  | 22
 | 2022 | 1 | 4 |  |  |  |  |  |  |  | 3 |  | 6 |  | 5 |  | 9 | 9 | 4 | 1 |  | 10 |  |  |  | 22
 | 2022 | 1 | 5 |  |  |  |  |  |  |  | 1 |  | 11 | 1 | 3 |  | 1 | 3 | 2 |  |  | 9 |  |  |  | 16
 | 2022 | 1 | 6 |  |  |  |  |  |  |  | 4 |  | 1 | 5 | 7 |  |  | 9 | 3 | 4 |  | 15 |  |  |  | 38
 | 2022 | 1 | 7 |  |  |  |  |  |  |  | 10 |  | 1 | 4 |  |  | 6 | 2 |  | 7 |  | 16 |  |  |  | 40
 | 2022 | 1 | 8 |  |  |  |  |  |  |  |  |  |  |  | 3
 | 2022 | 1 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 2022 | 1 | 10 |  |  |  |  |  |  |  | 8 |  | 1 | 35 | 3 |  | 1 | 14 |  | 7 |  | 19 | 9 |  |  | 13
 | 2022 | 1 | 11 |  |  |  |  |  |  |  | 13 |  | 2 | 24 | 7 |  |  | 2 | 1 | 6 |  | 19 | 6 |  |  | 29
 | 2022 | 1 | 12 |  |  |  |  |  |  |  | 15 |  | 4 | 13 |  |  |  | 3 | 1 |  |  | 7 | 2 |  |  | 7
 | 2022 | 1 | 13 |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 3
 | 2022 | 1 | 14 |  |  |  |  |  |  |  | 4 |  |  |  |  |  | 4
 | 2022 | 1 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | 2022 | 1 | 17 |  |  |  |  |  |  |  |  |  | 7 | 1 |  |  |  | 10 | 2 |  |  | 18 | 12 |  |  | 6
 | 2022 | 1 | 18 |  |  |  |  |  |  |  |  |  | 5 |  | 4 |  |  | 11 | 1 | 3 |  | 24 | 21 |  |  | 8
 | 2022 | 1 | 19 |  |  |  |  |  |  |  | 2 |  |  |  | 2 |  |  | 7 |  | 2 |  | 20 | 29 |  |  | 5
 | 2022 | 1 | 20 |  |  |  |  |  |  |  | 3 |  | 9 |  | 2 |  |  | 6 |  | 1 |  | 24 | 25 |  |  | 13
 | 2022 | 1 | 21 |  |  |  |  |  |  |  | 14 |  | 2 |  |  |  |  | 6 |  | 5 |  | 10 | 23
 | 2022 | 1 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 | 2022 | 1 | 24 |  |  |  |  |  |  |  | 18 |  | 5 |  | 1 |  |  | 6 |  | 4 |  | 8 | 29 |  |  | 25
 | 2022 | 1 | 25 |  |  |  |  |  |  |  | 23 | 14 | 11 | 23 |  |  | 8 | 6 | 4 | 3 |  | 11 | 32 |  |  | 20
 | 2022 | 1 | 26 |  |  |  |  |  |  |  | 5 | 21 | 5 | 13 |  |  | 2 | 12 | 1 | 2 |  | 6 | 10 |  |  | 8
 | 2022 | 1 | 27 |  |  |  |  |  |  |  | 16 | 25 | 8 | 30 | 1 |  |  | 10 | 4 |  |  | 14 | 10 |  |  | 15
 | 2022 | 1 | 28 |  |  |  |  |  |  |  | 21 | 24 | 11 | 10 |  |  | 4 | 7 |  | 6 |  | 27 | 19 |  |  | 28
 | 2022 | 1 | 31 |  |  |  |  |  |  |  | 21 | 17 |  | 17 | 2 |  | 1 | 13 | 3 | 1 |  | 14 | 54 |  |  | 17
 | 2022 | 2 | 1 |  |  |  |  |  |  |  |  | 33 | 3 | 47 |  |  | 5 | 8 | 1 | 5 |  | 8 | 55 |  |  | 16
 | 2022 | 2 | 2 |  |  |  |  |  |  |  | 15 | 32 | 3 | 37 |  |  |  | 12 | 1 | 4 |  | 31 | 52 |  |  | 14
 | 2022 | 2 | 3 |  |  |  |  |  |  |  | 25 | 21 |  | 34 | 1 |  |  |  |  |  |  | 5 | 44 |  |  | 15
 | 2022 | 2 | 4 |  |  |  |  |  |  |  | 17 | 20 |  | 29 |  |  |  | 5 |  | 8 |  |  | 14 |  |  | 10
 | 2022 | 2 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 | 2022 | 2 | 6 |  |  |  |  |  |  |  |  |  | 6
 | 2022 | 2 | 7 |  |  |  |  |  |  |  | 17 |  |  | 20 |  |  | 3 | 9 | 3 | 9 |  | 8 | 42 |  |  | 10
 | 2022 | 2 | 8 |  |  |  |  |  |  |  | 21 | 13 | 15 | 23 |  |  |  | 9 | 1 | 7 |  | 10 | 26
 | 2022 | 2 | 9 |  |  |  |  |  |  |  | 15 | 7 | 11 | 34 | 2 |  |  | 4 | 3 | 4 |  | 17 | 14
 | 2022 | 2 | 10 |  |  |  |  |  |  |  | 20 | 8 | 5 | 39 | 8 |  |  | 4 | 3 | 5 |  | 15 | 17 |  |  | 4
 | 2022 | 2 | 11 |  |  |  |  |  |  |  |  | 8 | 5 | 36 |  |  | 3 | 9 | 2 | 3 |  | 19 |  |  |  | 4
 | 2022 | 2 | 12 |  |  |  |  |  |  |  | 10 |  |  |  | 5
 | 2022 | 2 | 14 |  |  |  |  |  |  |  | 16 | 8 | 3 | 47 | 6 |  | 2 | 13 | 2 | 19 |  | 8 | 38 |  |  | 2
 | 2022 | 2 | 15 |  |  |  |  |  |  |  | 7 | 3 | 3 | 66 | 4 |  |  | 5 | 2 | 10 |  | 10 | 9 |  |  | 11
 | 2022 | 2 | 16 |  |  |  |  |  |  |  | 14 | 3 | 8 | 81 | 6 |  |  | 2 |  | 3 |  | 16 |  |  |  | 7
 | 2022 | 2 | 17 |  |  |  |  |  |  |  | 9 | 8 |  | 60 | 6 |  | 4 | 3 | 1 |  |  | 15 | 7 |  |  | 7
 | 2022 | 2 | 18 | 1 | 1 |  |  |  |  | 1 | 16 | 14 | 11 | 46 |  |  | 8 |  | 2 |  |  | 18 | 32 | 1 |  | 6
 | 2022 | 2 | 19 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
 | 2022 | 2 | 21 |  | 2 | 1 |  |  |  |  | 13 | 13 | 12 | 71 |  |  | 8 | 5 | 2 | 9 |  | 19 | 22 | 2 |  | 4
 | 2022 | 2 | 22 |  |  |  |  |  |  |  | 19 | 12 | 12 | 90 | 3 |  |  | 4 | 2 | 7 |  | 9 | 11 |  |  | 8
 | 2022 | 2 | 23 |  | 1 |  | 1 | 5 |  |  | 10 | 4 | 5 | 44 | 1 |  |  | 1 |  | 14 | 3 | 13 | 9 | 2 |  | 2
 | 2022 | 2 | 24 |  |  |  | 6 |  |  |  | 11 | 4 | 3 | 30 | 7 | 14 | 2 | 2 |  | 27 |  | 14 |  | 10
 | 2022 | 2 | 25 |  |  |  |  |  |  |  | 5 |  | 3 |  |  | 4 |  | 3 |  | 17 | 2 | 9 |  | 13 |  | 3
 | 2022 | 2 | 26 |  |  |  |  |  |  |  |  |  |  | 55 | 3
 | 2022 | 2 | 28 |  |  | 6 | 1 | 15 |  | 8 | 7 | 4 | 6 | 50 | 9 |  |  | 2 |  | 6 |  | 11 | 15 | 9
 | 2022 | 3 | 1 |  |  | 3 |  | 6 |  | 4 | 8 | 10 | 8 | 31 | 6 |  |  | 1 |  |  |  | 16 |  | 6 | 1 | 1
 | 2022 | 3 | 2 |  |  | 5 | 1 | 6 |  | 3 | 12 | 3 | 9 | 35 |  |  |  | 2 |  | 5 |  | 17 | 1 | 7
 | 2022 | 3 | 3 |  |  |  | 1 | 6 |  | 2 | 7 |  | 6 | 32 | 7 |  |  |  |  | 8 |  | 8 |  | 6 | 2 | 6
 | 2022 | 3 | 4 |  |  | 7 |  | 8 |  | 9 | 6 |  | 8 | 28 |  | 6 | 2 | 3 |  | 14 | 2 | 12 |  | 19
 | 2022 | 3 | 5 |  |  | 3 |  |  |  |  |  | 9 |  |  | 5 |  |  |  |  | 4
 | 2022 | 3 | 7 |  |  | 9 |  | 9 |  | 6 | 8 | 7 | 2 | 34 | 13 | 6 |  | 4 |  | 7 | 7 | 7 | 19 | 17 | 3 | 3
 | 2022 | 3 | 8 |  |  | 14 | 2 | 16 |  | 11 | 1 | 11 | 5 | 42 | 9 | 18 |  | 10 |  | 11 | 26 | 8 | 8 | 17 | 1 | 2
 | 2022 | 3 | 9 |  | 2 | 14 | 2 | 15 |  |  | 5 |  | 13 | 48 | 13 | 12 |  | 3 |  | 13 | 24 | 16 | 5 | 12 | 6
 | 2022 | 3 | 10 | 2 | 2 | 13 | 2 | 12 |  | 9 | 4 | 15 | 12 | 33 | 11 | 13 |  | 5 |  | 8 | 19 |  |  | 13 | 10 | 7
 | 2022 | 3 | 11 | 1 |  | 10 | 2 | 12 | 1 | 5 | 5 | 6 | 10 | 27 |  | 4 | 1 | 5 |  | 7 | 12 | 9 |  | 9 | 8 | 3
 | 2022 | 3 | 12 |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 13 | 4
 | 2022 | 3 | 14 | 3 | 3 | 5 | 1 | 9 |  | 8 | 12 | 10 | 12 | 23 | 9 | 9 |  | 4 |  | 15 | 11 | 8 | 3 | 13 | 6 | 4
 | 2022 | 3 | 15 | 1 | 3 | 17 | 7 | 13 |  | 14 | 11 | 21 | 10 | 26 | 10 | 14 |  | 4 |  | 11 | 18 | 19 | 2 | 20 | 2 | 1
 | 2022 | 3 | 16 | 2 | 7 | 20 | 1 | 11 | 7 | 12 | 2 | 11 | 2 | 10 | 3 | 13 |  |  |  | 10 | 16 | 2 | 11 | 7 | 3 | 2
 | 2022 | 3 | 17 | 3 | 6 | 21 |  | 11 |  | 17 | 11 | 4 | 2 | 40 | 3 | 16 |  | 2 |  | 11 | 29 | 16 |  | 16
 | 2022 | 3 | 18 | 3 | 4 | 12 | 5 | 11 | 8 | 11 | 7 |  |  |  |  | 12 |  | 1 |  | 4 | 4 | 16 |  | 9 |  | 2
 | 2022 | 3 | 19 |  |  |  |  |  |  |  |  |  |  | 42 | 9 |  |  |  |  |  |  |  |  |  |  | 3
 | 2022 | 3 | 21 | 5 | 7 | 17 | 2 | 14 | 17 | 12 | 11 | 14 | 7 | 31 | 9 | 4 |  | 4 |  | 14 | 11 | 17 |  | 11 |  | 5
 | 2022 | 3 | 22 | 2 | 7 | 18 | 8 |  | 22 | 10 | 18 | 8 | 10 | 28 | 2 | 5 |  | 5 |  | 11 | 14 | 9 | 7 | 10 |  | 8
 | 2022 | 3 | 23 | 1 |  | 17 | 5 | 8 | 7 | 2 | 6 |  | 3 | 7 | 5 | 12 |  |  |  | 5 | 9 | 10 |  | 9
 | 2022 | 3 | 24 | 2 | 3 | 14 | 6 | 8 | 4 | 17 | 16 |  |  | 48 | 15 | 7 |  | 1 |  | 5 | 8 | 5 |  | 11 | 2 | 2
 | 2022 | 3 | 25 | 2 | 2 | 11 | 6 | 4 |  | 11 | 13 |  | 1 | 33 |  |  |  |  |  | 1 | 12 | 6 |  | 24 |  | 3
 | 2022 | 3 | 26 |  |  |  |  |  |  |  | 8 |  |  |  | 19 | 6
 | 2022 | 3 | 28 | 6 | 8 | 18 | 6 | 6 | 11 | 8 | 8 |  |  | 7 | 4 | 5 |  |  |  |  | 16 | 7 | 2 | 17
 | 2022 | 3 | 29 | 1 | 4 | 14 | 6 | 11 | 14 | 10 | 4 |  | 1 | 1 | 6 | 4 |  |  |  |  | 21 | 3 |  | 17
 | 2022 | 3 | 30 | 3 | 5 | 17 | 3 | 10 | 8 | 10 | 4 | 1 |  | 22 | 14 | 9 |  | 4 |  | 1 | 13 | 8 | 1 | 12 |  | 2
 | 2022 | 3 | 31 | 8 | 6 | 18 |  | 4 | 5 | 12 | 6 | 7 |  | 28 | 9 | 10 |  | 1 |  |  | 16 | 9 |  | 30 | 2 | 1
 | 2022 | 4 | 1 | 2 | 4 | 16 | 5 | 9 | 10 | 3 | 3 | 5 |  | 29 |  |  |  |  |  |  | 2 |  | 2
 | 2022 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  | 8 |  | 2 |  | 1
 | 2022 | 4 | 4 | 10 | 1 | 21 | 7 | 10 | 5 | 12 | 8 | 7 |  | 27 | 3 |  |  |  |  |  | 2 | 7 |  | 11 |  | 2
 | 2022 | 4 | 5 | 2 | 12 | 18 | 6 | 11 | 8 | 10 | 11 | 9 |  | 34 | 2 | 2 |  |  |  |  |  | 16 |  | 20
 | 2022 | 4 | 6 | 9 | 12 | 16 | 2 | 21 | 15 | 2 | 17 | 10 |  | 27 | 7 | 4 |  | 7 | 3 |  | 3 | 11 |  | 6
 | 2022 | 4 | 7 | 7 | 14 | 25 |  | 15 | 4 | 8 | 9 | 20 |  | 43 |  | 16 |  | 1 |  |  | 3 | 8 | 3 | 8
 | 2022 | 4 | 8 | 5 | 8 | 14 | 7 | 16 | 11 | 8 | 5 | 5 |  | 22 |  | 11 |  | 2 |  |  |  | 9 |  | 14 |  | 1
 | 2022 | 4 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | 1
 | 2022 | 4 | 11 | 6 | 6 | 20 | 10 | 8 | 13 |  | 5 | 10 |  | 18 |  | 22 |  |  |  |  |  | 12 | 7 | 12
 | 2022 | 4 | 12 | 6 | 8 | 18 |  | 13 | 19 |  | 4 | 9 |  | 15 |  | 20 | 2 | 5 |  |  |  | 18 | 5 | 7 |  | 1
 | 2022 | 4 | 13 | 4 | 1 | 20 | 2 | 9 | 11 |  | 11 | 3 |  | 11 |  | 17 | 1 | 5 |  |  | 7 | 7 | 5 | 11 |  | 1
 | 2022 | 4 | 14 | 5 | 6 | 20 | 4 | 10 | 8 |  | 2 | 11 |  |  |  | 4 |  | 2 | 3 |  |  | 5 | 5 | 10 |  | 1
 | 2022 | 4 | 15 | 8 | 12 | 11 | 3 | 12 | 8 |  |  | 2 |  | 29 |  |  |  | 1 |  |  |  | 10 | 4 | 5
 | 2022 | 4 | 16 |  |  |  |  |  |  |  |  |  |  | 45
 | 2022 | 4 | 18 | 9 | 8 | 17 | 1 | 15 |  |  | 8 |  |  | 23 |  |  |  | 8 |  |  |  | 16 | 5 | 9 |  | 1
 | 2022 | 4 | 19 | 3 | 11 | 24 | 2 | 10 | 14 |  | 4 | 9 |  | 24 |  | 4 |  | 2 | 3 |  | 1 | 22 | 8 | 13 |  | 1
 | 2022 | 4 | 20 | 3 | 13 | 18 | 5 | 8 | 11 |  | 10 | 4 |  | 29 |  | 12 |  |  | 1 |  | 2 | 4 | 6 | 6 |  | 2
 | 2022 | 4 | 21 | 4 | 17 | 14 | 2 | 22 | 3 |  | 9 | 18 |  | 18 |  | 7 |  | 6 |  |  | 5 | 6 | 12 | 4
 | 2022 | 4 | 22 | 5 | 8 | 12 | 1 | 14 | 16 |  |  |  |  | 22 |  |  |  | 4 |  |  | 12 | 13 | 13 | 23
 | 2022 | 4 | 23 |  |  |  |  |  | 7 |  | 10 | 19 |  |  |  | 13
 | 2022 | 4 | 25 | 10 | 11 | 1 | 2 | 7 |  |  | 12 | 19 |  | 27 | 1 | 4 |  | 7 |  |  | 23 | 11 | 13 | 34 |  | 3
 | 2022 | 4 | 26 | 15 | 8 | 20 | 5 |  | 13 |  | 22 | 28 |  | 36 |  | 3 |  |  |  |  | 14 | 23 | 10 | 28 |  | 3
 | 2022 | 4 | 27 | 9 | 16 | 17 | 2 | 10 | 15 |  | 12 | 30 |  | 7 |  | 8 |  | 2 |  |  | 15 |  | 6 | 23 | 1
 | 2022 | 4 | 28 | 9 | 6 | 18 | 6 | 15 | 15 |  | 19 | 21 |  |  | 10 | 16 |  | 2 |  |  | 13 | 3 | 6 | 17
 | 2022 | 4 | 29 | 3 | 11 | 14 | 1 | 25 | 14 |  | 15 | 25 |  | 9 |  | 9 |  | 1 |  |  | 13 | 1 |  | 21 | 7 | 1
 | 2022 | 4 | 30 |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  | 7
 | 2022 | 5 | 2 | 4 | 8 | 14 | 4 | 15 |  |  | 19 | 12 |  | 20 | 21 | 20 | 1 | 3 |  |  | 23 | 14 | 6 | 26 | 8 | 1
 | 2022 | 5 | 3 | 6 | 4 | 14 | 8 | 11 | 17 |  | 15 | 13 |  | 19 | 29 | 10 |  | 4 |  |  | 26 | 26 | 2 | 35 | 10
 | 2022 | 5 | 4 | 6 | 5 | 16 | 6 | 8 | 15 |  | 6 | 9 |  | 8 | 17 | 5 | 2 |  | 1 |  | 18 | 12 | 7 | 19 | 6 | 1
 | 2022 | 5 | 5 | 6 | 10 | 23 |  | 23 | 5 |  | 12 | 7 |  | 51 | 17 | 24 |  |  |  |  | 19 | 8 | 7 | 25 | 6 | 1
 | 2022 | 5 | 6 | 4 | 4 | 25 | 1 | 15 | 5 |  | 6 | 4 |  | 51 |  | 13 |  | 7 |  |  | 18 |  | 3 | 15 |  | 2
 | 2022 | 5 | 7 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 11
 | 2022 | 5 | 9 | 6 | 6 | 22 | 3 | 8 | 15 |  | 14 | 21 |  | 29 | 19 | 15 |  | 6 |  |  | 15 | 20 | 5 | 26 | 17 | 2
 | 2022 | 5 | 10 | 5 | 10 | 11 | 5 | 18 | 9 |  | 13 | 33 |  | 55 | 16 | 14 |  | 4 |  |  | 19 | 14 | 2 | 31 | 5
 | 2022 | 5 | 11 | 4 | 6 | 14 | 2 | 11 | 12 |  | 6 | 18 |  | 16 | 14 | 15 |  | 7 |  |  | 10 | 9 | 5 | 22
 | 2022 | 5 | 12 | 5 | 5 | 26 | 4 | 18 | 17 |  | 14 | 18 |  | 4 | 18 | 21 |  | 1 |  |  | 16 | 12 | 13 | 26 | 2
 | 2022 | 5 | 13 | 1 | 1 |  |  |  | 2 |  |  | 4 |  |  |  | 2 |  | 1 |  |  |  |  |  | 3