Again untested.

=SUMPRODUCT(--(ISNA(MATCH(PaxData[Sector],Parameters!$C$5:$C$61,0))),--(PaxData[Driver]=Analysis!B6),--(PaxData[Date]>=Analysis!$C$1),--(PaxData[Date]<=Analysis!$C$2),PaxData[Pax])/SUMPRODUCT(--(ISNA(MATCH(PaxData[Sector],Parameters!$C$5:$C$61,0))),--(PaxData[Driver]=Analysis!B6),--(PaxData[Date]>=Analysis!$C$1),--(PaxData[Date]<=Analysis!$C$2))