| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
