Calculate Totals

[jimmy1981]

I'm trying to calculate several totals and have attached the sheet to make things clearer.

I have a train and a sumproduct formula that calculates how many passengers got on that train, what i need to do now is total up the different types of tickets those people used (taken from the INT Data sheet), row 3 is what it should return, but not sure i get it to work.

I thought a INDIRECT formula would be best but it's not really working.

any help appreciated.

Thanks

[romperstomper]

Duplicate (see here) so locked.