Forum Discussion
Create a excel which changes dynamically with two variables described below.
Hi Shivraj,
please see attached for my solution. I have created two tables. The first one contains timeslots, and the second one - the number of passengers in each timeslot. Then, I used SUMPRODUCT formula to summarise the number of passengers in the system up to the specified time, excluding those, whose flights have departed. If the departure times are in the range B12:B17, timeslots in D12:K17, the number of passengers in each timeslot in the range D21:K26, and the time entry range in the cell C29, then the formula to summarise the number of passengers in the system would be
=SUMPRODUCT($D$21:$K$26*($D$12:$K$17<=$C$29)*($B$12:$B$17>$C$29))
Yury
Hi Shivraj,
please see attached for my solution. I have created two tables. The first one contains timeslots, and the second one - the number of passengers in each timeslot. Then, I used SUMPRODUCT formula to summarise the number of passengers in the system up to the specified time, excluding those, whose flights have departed. If the departure times are in the range B12:B17, timeslots in D12:K17, the number of passengers in each timeslot in the range D21:K26, and the time entry range in the cell C29, then the formula to summarise the number of passengers in the system would be
=SUMPRODUCT($D$21:$K$26*($D$12:$K$17<=$C$29)*($B$12:$B$17>$C$29))
Yury
