Day | Train | Passengers |
Fri | 702 | 5 |
Fri | 752 | 10 |
Fri | 757X | 20 |
Fri | 737X | 2 |
Fri | 738X | 1 |
Fri | 700 | 100 |
Sat | 738X | 100 |
<tbody>
</tbody>
List |
702 |
752 |
757X |
737X |
738X |
<tbody>
</tbody>
I want the sum of passengers that meet the following two criteria: 1)Rode the Train on a Friday, 2)Rode a train that was on the List. Also, I want to be able to select the List in a range, versus having to type in each train on the List individually.
Is there a way to do this by combining SUMIFS, AND, and SUMPRODUCT ?