Spreadsheet: 857403d1706437164-sumif-giving-wrong-calculation-sss
Sheet: Sheet2

 |  | Start date | End date | Year | # of nights | Booked | Listing | Earnings
 |  | 2024-01-15 00:00:00 | 2024-02-12 00:00:00 |  | 28 | 45305 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 35671.14 |  |  |  | year | 2022 |  | 2024
 |  | 2024-01-14 00:00:00 | 2024-02-14 00:00:00 |  | 31 | 45296 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 40874.24
 |  | 2024-01-02 00:00:00 | 2024-03-06 00:00:00 |  | 64 | 45209 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 83355.27
 |  | 2023-12-26 00:00:00 | 2024-01-02 00:00:00 |  | 7 | 45285 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 9606.26
 |  | 2023-12-18 00:00:00 | 2024-01-15 00:00:00 |  | 28 | 45262 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 33977.2
 |  | 2023-12-09 00:00:00 | 2023-12-17 00:00:00 |  | 8 | 45269 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 10182.3
 |  | 2023-12-02 00:00:00 | 2024-01-09 00:00:00 |  | 38 | 45252 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 49885.57
 |  | 2023-11-27 00:00:00 | 2023-12-26 00:00:00 |  | 29 | 45245 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 38299.7
 |  | 2023-11-09 00:00:00 | 2023-12-08 00:00:00 |  | 29 | 45238 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 32683.25
 |  | 2023-10-26 00:00:00 | 2023-11-26 00:00:00 |  | 31 | 45202 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 40874.5
 |  | 2023-10-07 00:00:00 | 2023-11-04 00:00:00 |  | 28 | 45204 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 34912.13
 |  | 2023-10-02 00:00:00 | 2023-11-27 00:00:00 |  | 56 | 45191 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 68043.08
 |  | 2023-09-23 00:00:00 | 2023-10-07 00:00:00 |  | 14 | 45142 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 19938.63
 |  | 2023-09-16 00:00:00 | 2023-10-07 00:00:00 |  | 21 | 45182 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 25794.59
 |  | 2023-09-05 00:00:00 | 2023-09-23 00:00:00 |  | 18 | 45132 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 25475.23
 |  | 2023-09-05 00:00:00 | 2023-09-19 00:00:00 |  | 14 | 45166 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 16144.48
 |  | 2023-08-29 00:00:00 | 2023-09-10 00:00:00 |  | 12 | 45167 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 16846.18
 |  | 2023-08-16 00:00:00 | 2023-09-02 00:00:00 |  | 17 | 45151 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 23732.91
 |  | 2023-08-14 00:00:00 | 2023-08-24 00:00:00 |  | 10 | 45145 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 14542.69
 |  | 2023-07-26 00:00:00 | 2023-09-05 00:00:00 |  | 41 | 45105 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 45820.14
 |  | 2023-07-25 00:00:00 | 2023-08-16 00:00:00 |  | 22 | 45124 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 27594.75
 |  | 2023-07-15 00:00:00 | 2023-08-14 00:00:00 |  | 30 | 45120 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 32777.78
 |  | 2023-07-06 00:00:00 | 2023-07-18 00:00:00 |  | 12 | 45109 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 15678.19
 |  | 2023-07-03 00:00:00 | 2023-07-22 00:00:00 |  | 19 | 45076 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 24507.23
 |  | 2023-07-03 00:00:00 | 2023-07-12 00:00:00 |  | 9 | 45103 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 12814.92
 |  | 2023-06-22 00:00:00 | 2023-06-30 00:00:00 |  | 8 | 45097 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 9458.32
 |  | 2023-06-22 00:00:00 | 2023-06-29 00:00:00 |  | 7 | 45097 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 8397
 |  | 2023-06-16 00:00:00 | 2023-01-07 00:00:00 |  | 15 | 45086 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 20093.72
 |  | 2023-06-07 00:00:00 | 2023-06-15 00:00:00 |  | 8 | 45083 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 10774.66
 |  | 2023-05-31 00:00:00 | 2023-06-05 00:00:00 |  | 5 | 45076 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 8178.78
 |  | 2023-05-23 00:00:00 | 2023-06-05 00:00:00 |  | 13 | 45068 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 17430.92
 |  | 2023-05-22 00:00:00 | 2023-05-29 00:00:00 |  | 7 | 44933 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 0
 |  | 2023-05-03 00:00:00 | 2023-05-14 00:00:00 |  | 11 | 45046 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 15358.05
 |  | 2023-04-29 00:00:00 | 2023-06-12 00:00:00 |  | 44 | 45045 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 49783.75
 |  | 2023-04-27 00:00:00 | 2023-05-14 00:00:00 |  | 17 | 45037 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 0
 |  | 2023-04-18 00:00:00 | 2023-05-15 00:00:00 |  | 27 | 45032 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 33561.93
 |  | 2023-04-17 00:00:00 | 2023-04-24 00:00:00 |  | 7 | 45032 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 10182.15
 |  | 2023-04-07 00:00:00 | 2023-04-14 00:00:00 |  | 7 | 45003 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 11046.15
 |  | 2023-03-27 00:00:00 | 2023-04-04 00:00:00 |  | 8 | 45012 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 10840.39
 |  | 2023-03-26 00:00:00 | 2023-04-23 00:00:00 |  | 28 | 44995 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 34166.97
 |  | 2023-03-18 00:00:00 | 2023-04-14 00:00:00 |  | 27 | 44992 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 35267.85
 |  | 2023-03-02 00:00:00 | 2023-03-22 00:00:00 |  | 20 | 44977 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 28069.1
 |  | 2023-02-21 00:00:00 | 2023-03-20 00:00:00 |  | 27 | 44910 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 32727.12
 |  | 2023-02-12 00:00:00 | 2023-03-15 00:00:00 |  | 31 | 44964 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 37723.82
 |  | 2023-02-05 00:00:00 | 2023-02-18 00:00:00 |  | 13 | 44921 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 17010.87
 |  | 2023-01-21 00:00:00 | 2023-02-11 00:00:00 |  | 21 | 44941 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 25932.51
 |  | 2023-01-21 00:00:00 | 2023-02-11 00:00:00 |  | 21 | 44905 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 0
 |  | 2023-01-21 00:00:00 | 2023-02-04 00:00:00 |  | 14 | 44943 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 17228.59
 |  | 2023-01-14 00:00:00 | 2023-02-11 00:00:00 |  | 28 | 44912 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 25916.59
 |  | 2023-01-13 00:00:00 | 2023-02-10 00:00:00 |  | 28 | 44908 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 0
 |  | 2023-01-13 00:00:00 | 2023-01-16 00:00:00 |  | 3 | 44929 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 6049.37
 |  | 2023-01-06 00:00:00 | 2023-01-20 00:00:00 |  | 14 | 44846 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 17014.82
 |  | 2023-01-04 00:00:00 | 2023-01-13 00:00:00 |  | 9 | 44872 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 10586.3
 |  | 2022-12-25 00:00:00 | 2023-01-26 00:00:00 |  | 32 | 44831 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 0
 |  | 2022-12-25 00:00:00 | 2023-01-26 00:00:00 |  | 32 | 44831 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 0
 |  | 2022-12-25 00:00:00 | 2023-01-02 00:00:00 |  | 8 | 44885 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 9517.41
 |  | 2022-12-20 00:00:00 | 2023-01-03 00:00:00 |  | 14 | 44885 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 17228.54
 |  | 2022-11-24 00:00:00 | 2022-12-22 00:00:00 |  | 28 | 44849 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 27413.91
 |  | 2022-11-14 00:00:00 | 2022-11-22 00:00:00 |  | 8 | 44874 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 9517.64
 |  | 2022-11-13 00:00:00 | 2023-01-13 00:00:00 |  | 61 | 44875 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 62920.76
 |  | 2022-10-12 00:00:00 | 2022-12-17 00:00:00 |  | 66 | 44810 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 64687.13
 |  | 2022-10-02 00:00:00 | 2022-10-11 00:00:00 |  | 9 | 44834 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 0
 |  | 2022-09-15 00:00:00 | 2022-10-07 00:00:00 |  | 22 | 44769 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 0
 |  | 2022-09-13 00:00:00 | 2022-11-13 00:00:00 |  | 61 | 44803 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 55170.13
 |  | 2022-09-10 00:00:00 | 2022-10-19 00:00:00 |  | 39 | 44808 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 37185.86
 |  | 2022-09-08 00:00:00 | 2022-09-17 00:00:00 |  | 9 | 44812 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 0
 |  | 2022-08-01 00:00:00 | 2022-08-29 00:00:00 |  | 28 | 44756 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 27678.64
 |  | 2022-07-23 00:00:00 | 2022-08-26 00:00:00 |  | 34 | 44723 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 31846.99
 |  | 2022-07-10 00:00:00 | 2022-08-14 00:00:00 |  | 35 | 44729 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 0
 |  | 2022-07-10 00:00:00 | 2022-07-24 00:00:00 |  | 14 | 44746 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 17498.57
 |  | 2022-07-02 00:00:00 | 2022-07-09 00:00:00 |  | 7 | 44734 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 9475.29
 |  | 2022-06-07 00:00:00 | 2022-06-30 00:00:00 |  | 23 | 44680 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 26055.55
 |  | 2022-05-24 00:00:00 | 2022-06-01 00:00:00 |  | 8 | 44704 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 10832.61
 |  | 2022-05-22 00:00:00 | 2022-06-21 00:00:00 |  | 30 | 44688 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 28724.84
 |  | 2022-05-21 00:00:00 | 2022-06-06 00:00:00 |  | 16 | 44702 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 18567.62
 |  | 2022-05-10 00:00:00 | 2022-06-10 00:00:00 |  | 31 | 44681 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 0
 |  | 2022-05-06 00:00:00 | 2022-05-18 00:00:00 |  | 12 | 44687 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 14288.52
 |  | 2022-04-30 00:00:00 | 2022-05-16 00:00:00 |  | 16 | 44654 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 0
 |  | 2022-04-25 00:00:00 | 2022-05-23 00:00:00 |  | 28 | 44676 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 26414.13
 |  | 2022-04-23 00:00:00 | 2022-05-07 00:00:00 |  | 14 | 44656 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 0
 |  | 2022-04-08 00:00:00 | 2022-04-17 00:00:00 |  | 9 | 44658 | 5mins walk to BTS Thonglor; 1 bed fully furnished | 9749.46
 |  | 2022-03-31 00:00:00 | 2022-05-03 00:00:00 |  | 33 | 44650 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 31846.9
 |  | 2022-03-28 00:00:00 | 2022-03-30 00:00:00 |  | 2 | 44647 | 7mins walk to BTS Thonglor; easy access 1-bedroom | 2011.62
 |  | 2022-03-25 00:00:00 | 2022-04-09 00:00:00 |  | 15 | 44640 | 5-Mins walk to BTS Thonglor, Skyline One Bedroom | 14288.69