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