HI, I hope I formulated the topic correctly. What I want to do is to multiply Rooms by ADR for each date and sum them together to get total revenue for all days in a given segment (for example in row 5 and the result will be in cell S5). I thought of going with SUMPRODUCT but cannot figure out how. Can you please help? Thank you.
<tbody>
</tbody>
<tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
1 | 7-Aug | 7-Aug | 8-Aug | 8-Aug | 9-Aug | 9-Aug | 10-Aug | 10-Aug | 11-Aug | 11-Aug | 12-Aug | 12-Aug | 13-Aug | 13-Aug | Totals | ||||
2 | Monday | Monday | Tuesday | Tuesday | Wednesday | Wednesday | Thursday | Thursday | Friday | Friday | Saturday | Saturday | Sunday | Sunday | |||||
3 | Rooms | ADR | Rooms | ADR | Rooms | ADR | Rooms | ADR | Rooms | ADR | Rooms | ADR | Rooms | ADR | Rooms | % | Revenue | ||
4 | RACK | var | -1 | $12.78 | 0 | $13.76 | 6 | $44.68 | 3 | $39.83 | 3 | $81.55 | 3 | -$18.26 | 1 | -$28.16 | 15 | 3% | $(118.12) |
5 | D1 | 4 | $117.86 | 4 | $117.86 | 7 | $134.06 | 7 | $144.43 | 5 | $175.84 | 5 | $147.84 | 4 | $141.91 | 36 | 6.96% | $ - | |
6 | D2 | 5 | $105.08 | 4 | $104.10 | 1 | $89.38 | 4 | $104.60 | 2 | $94.29 | 2 | $166.10 | 3 | $170.07 | 21 | 5.87% | $ 118.12 | |
7 | Internet | var | 21 | $19.77 | 18 | $14.87 | 20 | $9.47 | 18 | $16.75 | 13 | $11.34 | 9 | $14.09 | 9 | $18.03 | 108 | 21% | $ 10.74 |
8 | D1 | 34 | $106.71 | 32 | $110.47 | 33 | $109.77 | 37 | $111.28 | 51 | $135.27 | 53 | $138.06 | 30 | $126.01 | 270 | 52.22% | $ 121.85 | |
9 | D2 | 13 | $86.94 | 14 | $95.60 | 13 | $100.30 | 19 | $94.53 | 38 | $123.93 | 44 | $123.97 | 21 | $107.98 | 162 | 45.25% | $ 111.11 | |
10 | Other Discounts | var | 5 | -$18.05 | 5 | -$16.43 | 5 | $22.48 | 8 | $32.87 | 0 | $38.53 | -5 | $26.76 | 0 | $12.85 | 18 | 3% | $ 16.40 |
11 | D1 | 25 | $128.27 | 17 | $140.33 | 17 | $150.72 | 21 | $150.07 | 31 | $160.05 | 34 | $166.58 | 23 | $132.97 | 168 | 32.50% | $ 148.75 | |
12 | D2 | 20 | $146.32 | 12 | $156.76 | 12 | $128.24 | 13 | $117.20 | 31 | $121.52 | 39 | $139.82 | 23 | $120.12 | 150 | 41.90% | $ 132.35 | |
13 | Rack, Internet, Discounts Totals | var | 25 | -$4.61 | 23 | -$0.59 | 31 | $12.19 | 29 | $23.55 | 16 | $24.39 | 7 | $16.90 | 10 | $12.05 | 141 | 27% | $ 11.72 |
14 | D1 | 63 | $115.97 | 53 | $120.61 | 57 | $124.97 | 65 | $127.38 | 87 | $146.43 | 92 | $149.13 | 57 | $129.93 | 474 | 91.68% | $ 132.84 | |
15 | D2 | 38 | $120.58 | 30 | $121.20 | 26 | $112.78 | 36 | $103.84 | 71 | $122.04 | 85 | $132.23 | 47 | $117.88 | 333 | 93.02% | $ 121.12 |
<tbody>
</tbody>
<tbody>
</tbody>