Formula

[Shahzad]

This formula is workable in Office 2007.
Please advise relevant formula in Office 2003.

=COUNTIFS(M3:M17,"=MAN",P317,"=2000")+(COUNTIFS(M3:M17,"=LHR",P317,"=2000"))


Regards

Shahzad

 

[Max]

Venturing a guess:
=SUMPRODUCT((M3:M17="MAN")*(P317=2000)+(M3:M17="LHR")*(P317=2000))

 

[Teethless mama]

=SUMPRODUCT((M3:M17={"MAN","LHR"})*(P317=2000))