Multiple Arguments - New Twist
 

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(D6:D11,"0")*1495 to calculate tuition for grades 1-12
if they are local students. If D6:D11 contains numbers 1-12, and the
Adjacent column E6:E11 contains the word "Local", 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: http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=520960

Multiple Arguments - New Twist
 

Just adapt it

=SUMPRODUCT(--(D6:D11=1),--(D6:D11<=12),--(E6:E11="Local"))*1495

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dansargeant"
wrote in message
...

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(D6:D11,"0")*1495 to calculate tuition for grades 1-12
if they are local students. If D6:D11 contains numbers 1-12, and the
Adjacent column E6:E11 contains the word "Local", 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:
http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=520960

Multiple Arguments - New Twist
 

Hi Bob,

Thanks for the Help! 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=520960