[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Day[/TD]
[TD]Train[/TD]
[TD]Passengers[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]702[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]752[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]757X[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]737X[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]738X[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]700[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD]738X[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]List[/TD]
[/TR]
[TR]
[TD]702[/TD]
[/TR]
[TR]
[TD]752[/TD]
[/TR]
[TR]
[TD]757X[/TD]
[/TR]
[TR]
[TD]737X[/TD]
[/TR]
[TR]
[TD]738X[/TD]
[/TR]
</tbody>[/TABLE]
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 ?
<tbody>[TR]
[TD]Day[/TD]
[TD]Train[/TD]
[TD]Passengers[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]702[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]752[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]757X[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]737X[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]738X[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]700[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD]738X[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]List[/TD]
[/TR]
[TR]
[TD]702[/TD]
[/TR]
[TR]
[TD]752[/TD]
[/TR]
[TR]
[TD]757X[/TD]
[/TR]
[TR]
[TD]737X[/TD]
[/TR]
[TR]
[TD]738X[/TD]
[/TR]
</tbody>[/TABLE]
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 ?