software

Hi to all,
Biff helped me wonderfully with a similar problem a few minutes ago.
This is so similar but the same function will not work. I'm using this
formula =COUNTIF(D611,quot;gt;0quot;)*1495 to calculate tuition for grades 1-12
if they are local students. If D611 contains numbers 1-12, and the
Adjacent column E6:E11 contains the word quot;Localquot;, I want it to multply
by 1495. What formula will check for these two arguments?

Thanks to anyone who can help

Dan--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: www.excelforum.com/member.php...oamp;userid=13852
View this thread: www.excelforum.com/showthread...hreadid=520960Just adapt it

=SUMPRODUCT(--(D611gt;=1),--(D611lt;=12),--(E6:E11=quot;Localquot;))*1495

you maybe don't need the lt;=12 check, just my caution.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;dansargeantquot; gt;
wrote in message
...
gt;
gt; Hi to all,
gt; Biff helped me wonderfully with a similar problem a few minutes ago.
gt; This is so similar but the same function will not work. I'm using this
gt; formula =COUNTIF(D611,quot;gt;0quot;)*1495 to calculate tuition for grades 1-12
gt; if they are local students. If D611 contains numbers 1-12, and the
gt; Adjacent column E6:E11 contains the word quot;Localquot;, I want it to multply
gt; by 1495. What formula will check for these two arguments?
gt;
gt; Thanks to anyone who can help
gt;
gt; Dan
gt;
gt;
gt; --
gt; dansargeant
gt; ------------------------------------------------------------------------
gt; dansargeant's Profile:
www.excelforum.com/member.php...oamp;userid=13852
gt; View this thread: www.excelforum.com/showthread...hreadid=520960
gt;

Hi Bob,

Thanks for the Help! It worked great!!
DS--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: www.excelforum.com/member.php...oamp;userid=13852
View this thread: www.excelforum.com/showthread...hreadid=520960