COUNTIF with two criteria's

[Holly]

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'!D57,"C")+('2006 PMR Schedule'!E5:E7,"GTS")

 

[Dave F]

Try:

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

Dave

 

[Holly]

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]

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

Dave

 

[Holly]

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