Try:

=COUNTIF('2006 PMR Schedule'!D5:D7,"C")+COUNTIF('2006 PMR
Schedule'!E5:E7,"GTS")

Dave
--
Brevity is the soul of wit.


"Holly" wrote:

Hi,
I am trying to add one more criteria to the below formula and cannot figure
it out.
Need to locate how many "C" with "GTS". Both are in different rows.
This is what I did..but it doesn't work and have been working on this for
the past couple of days. Pls help..thank you

=countif('2006 PMR Schedule'!D5:D7,"C")+('2006 PMR Schedule'!E5:E7,"GTS")