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