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

's Computer Specifications

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

Please forward answer to (E-Mail Removed)

Regards
Shahzad

's Computer Specifications

=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" <(E-Mail Removed)> wrote in message
news:F0AA943D-85D4-46A3-9FAE-(E-Mail Removed)...
> This formula is workable in Office 2007.
> Please advise relevant formula in Office 2003.
>
> Please forward answer to (E-Mail Removed)
>
>
> Regards
> Shahzad
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Field Names: "LongName", "ShortName", "Code", "Description","Comments"	PeteCresswell	Microsoft Access	2	25th Feb 2009 11:41 PM
ReVIEW (Erratum): some shortcut keys not working anymore-----help""""""""PhpApach...WORK WELL!!!!	wbrowse@gmail.com	Windows XP Help	0	13th Apr 2007 12:29 PM
<FORM METHOD="post" onSubmit="return fieldcheck()" name="orientation" action="http://ws-kitty.BU.edu/AT/survey/orientation/script/write.asp" language="JavaScript">	Joeyej	Microsoft ASP .NET	0	4th Jun 2004 08:55 PM
Manual "Windows Update" produces "ActiveX/active scripting" error message even with "LOW" security level setting in "Trusted" Zone	Ray2	Windows XP Help	1	14th Nov 2003 06:50 PM