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

S

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
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 2
Excel 2000 - Help with Countif needed 2
Enable autofilter in protected worksheets in Excel 2000 6
Unable to connect to Exchange 2000 Server from Outlook 2007 2
Open with one Access application another Access application 11
Open One Access application with the other 0
Upgrading to Office 2003 (or 2007), Leave Outlook 2000 0
IPersistFile::Save not working with Word 2007 1

Top