It is a different rooms, different rooms have different consumption.
A to D column is the details of the consumer, I to O column is room check-in and check-out date.
Now you need to find the room during the period of living consumption.
For example 3161 guest rooms (m1) during check-in $32 (B7) consumption, 0851 (O20) during the period of stay in a $65 + $42 (bl3 + B14) consumption.
Excuse me, can use a VLOOKUP function with the IF all related consumption according to the room to find out?