Multiple Arguments - New Twist

[dansargeant]

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,">0")*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 "Local", I want it to multply
by 1495. What formula will check for these two arguments?

Thanks to anyone who can help

Dan

 

[Bob Phillips]

Just adapt it

=SUMPRODUCT(--(D611>=1),--(D611<=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" <[email protected]>
wrote in message
news:[email protected]...

 

[dansargeant]

Hi Bob,

Thanks for the Help! It worked great!!
DS