COUNTIF with two criteria's
 

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")

COUNTIF with two criteria's
 

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")

COUNTIF with two criteria's
 

Hi Dave, thanks for the help.. now looking at it I am getting more than what
I want. What I am trying to do is have a count of how many GTS has an A, how
many GTS has a B, etc. When I add the +COUNTIF it adds both and comes back
with "2" - when the raw data shows "1".. any ideas ?


GBS/GTS Health Rating

GBS A
GTS B
GBS B



"Dave F" wrote:

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")

COUNTIF with two criteria's
 

Sounds like you need to use SUMPRODUCT:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Dave
--
Brevity is the soul of wit.


"Holly" wrote:

Hi Dave, thanks for the help.. now looking at it I am getting more than what
I want. What I am trying to do is have a count of how many GTS has an A, how
many GTS has a B, etc. When I add the +COUNTIF it adds both and comes back
with "2" - when the raw data shows "1".. any ideas ?


GBS/GTS Health Rating

GBS A
GTS B
GBS B



"Dave F" wrote:

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")

COUNTIF with two criteria's
 

THAT WAS IT !!!! Figured it out FINALLY.
Thank you very much for your direction ! Have an awesome day !

"Dave F" wrote:

Sounds like you need to use SUMPRODUCT:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Dave
--
Brevity is the soul of wit.


"Holly" wrote:

Hi Dave, thanks for the help.. now looking at it I am getting more than what
I want. What I am trying to do is have a count of how many GTS has an A, how
many GTS has a B, etc. When I add the +COUNTIF it adds both and comes back
with "2" - when the raw data shows "1".. any ideas ?


GBS/GTS Health Rating

GBS A
GTS B
GBS B



"Dave F" wrote:

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")