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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - =COUNTIFS(M3:M17,"=MAN",P3:P17,"=2000")+(COUNTIFS( M3:M17,"=LHR",P (https://www.excelbanter.com/excel-worksheet-functions/193399-%3Dcountifs-m3-m17-%3Dman-p3-p17-%3D2000-countifs-m3-m17-%3Dlhr-p.html)

shahzad

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

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

Please forward answer to

Regards
Shahzad

Bob Phillips

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

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

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

or

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

--
HTH

Bob

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

"Shahzad" wrote in message
...
This formula is workable in Office 2007.
Please advise relevant formula in Office 2003.

Please forward answer to

Regards
Shahzad

All times are GMT +1. The time now is 05:55 PM.