Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 criterias for countif - | Excel Worksheet Functions | |||
Countif, two criterias need help | Excel Worksheet Functions | |||
Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
countif help for multiple criterias | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions |