Spreadsheet: 688985d1596050039-countif-sumif-and-index-match-not-really-sure-what-i-need-but-i-need-help-parking-rent-roll-copy
Sheet: Sheet1

NOTES: | Spots 101-112 = $60 per month with a [NAME] length of 25’. Anything over 25’ needs to go in two spots between 113-120 Spots 113-120 = $60 per month per spot with a maximum length of 23’. So if they have a 40’ trailer, you’d have to charge them $120 per month for two spots. [NAME] lengths below: 1 spot: 23’ @ $60 2 spots: 46’ @ $120 3 spots: 69’ @ $180 4 spots: 92’ @ $240 5 spots: 115’ @ $300 | .
 | Monthly | Annual |  | Type | Price | Occupancy | Occupancy | Occupancy | Occupancy | Occupancy | Occupancy | Occupancy | Occupancy | Occupancy | Occupancy | Occupancy | Occupancy
Occupied |  |  |  | 19x9 | 30
Vacant |  |  |  | 23x9 | 40
Total |  |  |  | 25x11 | 60 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Price | Parking Spot # | Helper Cells | Helper Cells |  | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00 | 2027-07-01 00:00:00 | 2027-08-01 00:00:00 | 2027-09-01 00:00:00 | 2027-10-01 00:00:00 | 2027-11-01 00:00:00 | 2027-12-01 00:00:00 | 2028-01-01 00:00:00 | 2028-02-01 00:00:00 | 2028-03-01 00:00:00 | 2028-04-01 00:00:00 | 2028-05-01 00:00:00 | 2028-06-01 00:00:00 | 2028-07-01 00:00:00 | 2028-08-01 00:00:00 | 2028-09-01 00:00:00 | 2028-10-01 00:00:00 | 2028-11-01 00:00:00 | 2028-12-01 00:00:00 | 2029-01-01 00:00:00 | 2029-02-01 00:00:00 | 2029-03-01 00:00:00 | 2029-04-01 00:00:00 | 2029-05-01 00:00:00 | 2029-06-01 00:00:00 | 2029-07-01 00:00:00 | 2029-08-01 00:00:00 | 2029-09-01 00:00:00 | 2029-10-01 00:00:00
19x9 |  | 60 | 2 |  |  |  |  | E8 | E8 | E8 | E8 | E8 | E8 | E8 | E8
19x9 |  | 59 | 3 |  |  | [NAME] | [NAME] | E8 | E8 | E8 | E8 | E8 | E8 | E8 | E8
23x9 |  | 58 | 4 |  |  | [NAME] | [NAME] | E8 |  |  | E12 | E12 | E12 | E12 | E12
23x9 |  | 1 | 5 |  |  | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12
19x9 |  | 2 | 6 |  |  | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12
19x9 |  | 3 | 7 |  |  | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12
19x9 |  | 4 | 8 |  |  | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12
19x9 |  | 5 | 9 |  |  | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12
19x9 |  | 6 | 10 |  |  | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12 | B12
23x9 |  | 7 | 11 |  |  |  | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11
23x9 |  | 8 | 12 |  |  | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11
23x9 |  | 9 | 13 |  |  | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11
23x9 |  | 10 | 14 |  |  | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11 | B11
23x9 |  | 11 | 15 |  |  |  |  |  |  |  |  |  |  |  | B11
19x9 |  | 12 | 16 |  |  |  |  |  |  |  |  |  |  |  | B11
19x9 |  | 13 | 17 |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
19x9 |  | 14 | 18 |  |  | [NAME] | [NAME] |  |  |  |  | H
19x9 |  | 15 | 19 |  |  |  |  |  |  |  |  | H
19x9 |  | 16 | 20 |  |  |  |  |  |  |  |  | H
19x9 |  | 17 | 21 |  |  |  |  |  |  |  |  | B15 | B15 | B15 | B15
23x9 |  | 18 | 22 |  |  |  | B14 | B14 | B14 | B14 | B14 | B14 | B14 | B14 | B14
23x9 |  | 19 | 23 |  |  | C15 | C15 | C15 | C15 | C15 | C15 | C15 | C15 | C15 | C15
23x9 |  | 20 | 24 |  |  | C15 | C15 | C15 | C15 | C15 | C15
23x9 |  | 21 | 25 |  |  |  | C1 | C1 | C1 |  | C19 | C19 | C19 | C19 | C19
19x9 |  | 22 | 26 |  |  |  | C1 | C1 | C1 |  |  |  | H | C1 | C1
19x9 |  | 23 | 27 |  |  |  |  |  |  |  |  |  |  | C1 | C1
19x9 |  | 24 | 28 |  |  |  |  |  | C13
19x9 |  | 25 | 29 |  |  |  |  |  | E2 | E2 | E2 | E2 | E2 | E2 | E2
19x9 |  | 26 | 30 |  |  |  |  |  | E2 | E2 | E2 | E2 | E2 | E2 | E2
23x9 |  | 27 | 31 |  |  |  |  | D1 | D1 | D1 | D1 | D1 | D1 | D1 | D1
23x9 |  | 28 | 32 |  |  | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17
23x9 |  | 29 | 33 |  |  | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17
23x9 |  | 30 | 34 |  |  | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17
19x9 |  | 31 | 35 |  |  | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17
19x9 |  | 32 | 36 |  |  | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17
19x9 |  | 33 | 37 |  |  | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17 | D17
19x9 |  | 34 | 38 |  |  |  |  |  | D17 | D17 | D17 | D17 | D17 | D17 | D17
19x9 |  | 35 | 39 |  |  |  |  |  | E12 |  | E12 | E12 | E12 | D17 | D17
19x9 |  | 36 | 40 |  |  |  |  | H | H |  |  |  | H | H | H | H
23x9 |  | 37 | 41 |  |  |  | E3 | E3 | E3 | E3 | E3 | E3 | E3 | E3 | E3
23x9 |  | 38 | 42 |  |  |  | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11
23x9 |  | 39 | 43 |  |  |  | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11
23x9 |  | 40 | 44 |  |  |  | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11
19x9 |  | 41 | 45 |  |  |  | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11
19x9 |  | 42 | 46 |  |  | H | H | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11
19x9 |  | 43 | 47 |  |  |  |  | G11 | G11 | G11 | G11 | G11 | G11 | G11 | G11
19x9 |  | 44 | 48 |  |  | D17 | D17 | D17 | D17 |  |  |  |  | D17 | D17
19x9 |  | 45 | 49 |  |  | F15 | F17 | F17 | F17 | F17 | F17 | F17 | F17 | F17
23x9 |  | 46 | 50 |  |  | F17 | F17 | F17 |  |  |  |  |  |  | E6
23x9 |  | 47 | 51 |  |  | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F17 | F17
23x9 |  | 48 | 52 |  |  | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4
23x9 |  | 49 | 53 |  |  | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4
19x9 |  | 50 | 54 |  |  | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4
19x9 |  | 51 | 55 |  |  | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4 | F4
19x9 |  | 52 | 56 |  |  |  |  |  |  | G2 | G2 | G2 | G2 | G2 | G2
19x9 |  | 53 | 57 |  |  |  |  |  | G2 | G2 | G2 | G2 | G2 | G2 | G2
19x9 |  | 54 | 58 |  |  | F4 |  |  | G2 | G2 | G2 | G2 | G2 | G2 | G2
23x9 |  | 55 | 59 |  |  | F16 |  | F16 | F16 | F16 | F16 | F16 | F16 | F16 | F16
23x9 |  | 56 | 60 |  |  | F4 | F4 | M1 | M1 |  |  |  |  | M1 | F4 | F4
23x9 |  | 57 | 61 |  |  | L8 | L8 | L8 | L8 | L8 | L8 | L8 |  | [NAME] | F4 | F4
25x11 |  | 101 | 62
25x11 |  | 102 | 63
25x11 |  | 103 | 64
25x11 |  | 104 | 65
25x11 |  | 105 | 66
25x11 |  | 106 | 67
25x11 |  | 107 | 68
25x11 |  | 108 | 69
25x11 |  | 109 | 70
25x11 |  | 110 | 71
25x11 |  | 111 | 72
25x11 |  | 112 | 73
25x11 |  | 113 | 74
25x11 |  | 114 | 75
25x11 |  | 115 | 76
25x11 |  | 116 | 77
25x11 |  | 117 | 78
25x11 |  | 118 | 79
25x11 |  | 119 | 80
25x11 |  | 120 | 81