ExcelBanter - Formula

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

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

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/193400-formula.html)

shahzad

Formula

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

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

Regards

Shahzad

Max

Formula

Venturing a guess:
=SUMPRODUCT((M3:M17="MAN")*(P3:P17=2000)+(M3:M17=" LHR")*(P3:P17=2000))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Shahzad" wrote:
This formula is workable in Office 2007.
Please advise relevant formula in Office 2003.

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

Regards

Shahzad

Teethless mama

Formula

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

"Shahzad" wrote:

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

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

Regards

Shahzad

All times are GMT +1. The time now is 08:56 AM.