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