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