=COUNTIFS(M3:M17,"=MAN",P3:P17,"=2000")+(COUNTIFS(M3:M17,"=LHR",P

[Shahzad]

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

Please forward answer to (e-mail address removed)


Regards
Shahzad

 

[Bob Phillips]

=SUMPRODUCT(--(M3:M17="MAN"),--(P317=2000))+

SUMPRODUCT(--(M3:M17="LHR"),--(P317=2000))

or

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


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)