Spreadsheet: 761120d1640671312-income-by-location-sumproduct-pq_list_months
Sheet: Tabela1

Rate Per Day | Room | Single_days |  |  |  |  | Suma z Rate Per Day | Etykiety kolumn
50 | Room A | 2021-01-01 00:00:00 |  |  |  |  | Etykiety wierszy | Room A | Room B | Room C | Room D | Suma końcowa
50 | Room A | 2021-01-02 00:00:00 |  |  |  |  | sty | 1550 |  |  |  | 1550
50 | Room A | 2021-01-03 00:00:00 |  |  |  |  | lut | 550 | 1275 |  |  | 1825
50 | Room A | 2021-01-04 00:00:00 |  |  |  |  | kwi | 600 |  | 1650 |  | 2250
50 | Room A | 2021-01-05 00:00:00 |  |  |  |  | cze |  |  |  | 720 | 720
50 | Room A | 2021-01-06 00:00:00 |  |  |  |  | Suma końcowa | 2700 | 1275 | 1650 | 720 | 6345
50 | Room A | 2021-01-07 00:00:00
50 | Room A | 2021-01-08 00:00:00
50 | Room A | 2021-01-09 00:00:00
50 | Room A | 2021-01-10 00:00:00
50 | Room A | 2021-01-11 00:00:00
50 | Room A | 2021-01-12 00:00:00
50 | Room A | 2021-01-13 00:00:00
50 | Room A | 2021-01-14 00:00:00 |  |  | Answering the question from:
50 | Room A | 2021-01-15 00:00:00 |  |  | [NAME]
50 | Room A | 2021-01-16 00:00:00
50 | Room A | 2021-01-17 00:00:00
50 | Room A | 2021-01-18 00:00:00
50 | Room A | 2021-01-19 00:00:00
50 | Room A | 2021-01-20 00:00:00
50 | Room A | 2021-01-21 00:00:00
50 | Room A | 2021-01-22 00:00:00
50 | Room A | 2021-01-23 00:00:00
50 | Room A | 2021-01-24 00:00:00
50 | Room A | 2021-01-25 00:00:00
50 | Room A | 2021-01-26 00:00:00
50 | Room A | 2021-01-27 00:00:00
50 | Room A | 2021-01-28 00:00:00
50 | Room A | 2021-01-29 00:00:00
50 | Room A | 2021-01-30 00:00:00
50 | Room A | 2021-01-31 00:00:00
50 | Room A | 2021-02-01 00:00:00
50 | Room A | 2021-02-02 00:00:00
50 | Room A | 2021-02-03 00:00:00
50 | Room A | 2021-02-04 00:00:00
50 | Room A | 2021-02-05 00:00:00
50 | Room A | 2021-02-06 00:00:00
50 | Room A | 2021-02-07 00:00:00
50 | Room A | 2021-02-08 00:00:00
50 | Room A | 2021-02-09 00:00:00
50 | Room A | 2021-02-10 00:00:00
50 | Room A | 2021-02-11 00:00:00
75 | Room B | 2021-02-01 00:00:00
75 | Room B | 2021-02-02 00:00:00
75 | Room B | 2021-02-03 00:00:00
75 | Room B | 2021-02-04 00:00:00
75 | Room B | 2021-02-05 00:00:00
75 | Room B | 2021-02-06 00:00:00
75 | Room B | 2021-02-07 00:00:00
75 | Room B | 2021-02-08 00:00:00
75 | Room B | 2021-02-09 00:00:00
75 | Room B | 2021-02-10 00:00:00
75 | Room B | 2021-02-11 00:00:00
75 | Room B | 2021-02-12 00:00:00
75 | Room B | 2021-02-13 00:00:00
75 | Room B | 2021-02-14 00:00:00
75 | Room B | 2021-02-15 00:00:00
75 | Room B | 2021-02-16 00:00:00
75 | Room B | 2021-02-17 00:00:00
150 | Room C | 2021-04-01 00:00:00
150 | Room C | 2021-04-02 00:00:00
150 | Room C | 2021-04-03 00:00:00
150 | Room C | 2021-04-04 00:00:00
150 | Room C | 2021-04-05 00:00:00
150 | Room C | 2021-04-06 00:00:00
150 | Room C | 2021-04-07 00:00:00
150 | Room C | 2021-04-08 00:00:00
150 | Room C | 2021-04-09 00:00:00
150 | Room C | 2021-04-10 00:00:00
150 | Room C | 2021-04-11 00:00:00
50 | Room A | 2021-04-07 00:00:00
50 | Room A | 2021-04-08 00:00:00
50 | Room A | 2021-04-09 00:00:00
50 | Room A | 2021-04-10 00:00:00
50 | Room A | 2021-04-11 00:00:00
50 | Room A | 2021-04-12 00:00:00
50 | Room A | 2021-04-13 00:00:00
50 | Room A | 2021-04-14 00:00:00
50 | Room A | 2021-04-15 00:00:00
50 | Room A | 2021-04-16 00:00:00
50 | Room A | 2021-04-17 00:00:00
50 | Room A | 2021-04-18 00:00:00
60 | Room D | 2021-06-11 00:00:00
60 | Room D | 2021-06-12 00:00:00
60 | Room D | 2021-06-13 00:00:00
60 | Room D | 2021-06-14 00:00:00
60 | Room D | 2021-06-15 00:00:00
60 | Room D | 2021-06-16 00:00:00
60 | Room D | 2021-06-17 00:00:00
60 | Room D | 2021-06-18 00:00:00
60 | Room D | 2021-06-19 00:00:00
60 | Room D | 2021-06-20 00:00:00
60 | Room D | 2021-06-21 00:00:00
60 | Room D | 2021-06-22 00:00:00