Multiple Arguments

**dansargeant** · 03-10-2006, 02:53 AM

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

Biff · 03-10-2006, 03:45 AM

Hi!

Try this:

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

Biff

"dansargeant" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

**dansargeant** · 03-10-2006, 03:58 AM

Hey,

Thanks Biff!! It worked great!!

DS

Biff · 03-10-2006, 04:10 AM

You're welcome. Thanks for the feedback!

Biff

"dansargeant" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>