Multiple Arguments
 

I am using this formula =COUNTIF(D6:D11,"K9-3")*1995. I want it to only
return true and multiply by 1995 if E6:E11 also contains "Local" rather
than "Distance". How can I enter the formula so it will check both
arguments?


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=520943

Multiple Arguments
 

Hi!

Try this:

=SUMPRODUCT(--(D6:D11="K9-3"),--(E6:E11="Local"))*1995

Biff

"dansargeant"
wrote in message
...

I am using this formula =COUNTIF(D6:D11,"K9-3")*1995. I want it to only
return true and multiply by 1995 if E6:E11 also contains "Local" rather
than "Distance". How can I enter the formula so it will check both
arguments?


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile:
http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=520943

Multiple Arguments
 

Hey,

Thanks Biff!! It worked great!!

DS


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=520943

Multiple Arguments
 

You're welcome. Thanks for the feedback!

Biff

"dansargeant"
wrote in message
...

Hey,

Thanks Biff!! It worked great!!

DS


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile:
http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=520943