| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "countifs" convert to formula in XL2002 | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
