software

I am using this formula =COUNTIF(D611,quot;K9-3quot;)*1995. I want it to only
return true and multiply by 1995 if E6:E11 also contains quot;Localquot; rather
than quot;Distancequot;. How can I enter the formula so it will check both
arguments?--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: www.excelforum.com/member.php...oamp;userid=13852
View this thread: www.excelforum.com/showthread...hreadid=520943Hi!

Try this:

=SUMPRODUCT(--(D611=quot;K9-3quot;),--(E6:E11=quot;Localquot;))*1995

Biff

quot;dansargeantquot; gt;
wrote in message
...
gt;
gt; I am using this formula =COUNTIF(D611,quot;K9-3quot;)*1995. I want it to only
gt; return true and multiply by 1995 if E6:E11 also contains quot;Localquot; rather
gt; than quot;Distancequot;. How can I enter the formula so it will check both
gt; arguments?
gt;
gt;
gt; --
gt; dansargeant
gt; ------------------------------------------------------------------------
gt; dansargeant's Profile:
gt; www.excelforum.com/member.php...oamp;userid=13852
gt; View this thread: www.excelforum.com/showthread...hreadid=520943
gt;

Hey,

Thanks Biff!! It worked great!!

DS--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: www.excelforum.com/member.php...oamp;userid=13852
View this thread: www.excelforum.com/showthread...hreadid=520943You're welcome. Thanks for the feedback!

Biff

quot;dansargeantquot; gt;
wrote in message
...
gt;
gt; Hey,
gt;
gt; Thanks Biff!! It worked great!!
gt;
gt; DS
gt;
gt;
gt; --
gt; dansargeant
gt; ------------------------------------------------------------------------
gt; dansargeant's Profile:
gt; www.excelforum.com/member.php...oamp;userid=13852
gt; View this thread: www.excelforum.com/showthread...hreadid=520943
gt;