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?
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?
Last edited by dansargeant; 03-10-2006 at 03:37 AM.
Hi!
Try this:
=SUMPRODUCT(--(D6:D11="K9-3"),--(E6:E11="Local"))*1995
Biff
"dansargeant" <dansargeant.24fyxp_1141973710.1777@excelforum-nospam.com>
wrote in message
news:dansargeant.24fyxp_1141973710.1777@excelforum-nospam.com...
>
> 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
>
Hey,
Thanks Biff!! It worked great!!
DS
You're welcome. Thanks for the feedback!
Biff
"dansargeant" <dansargeant.24g1xy_1141977602.5647@excelforum-nospam.com>
wrote in message
news:dansargeant.24g1xy_1141977602.5647@excelforum-nospam.com...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks