Extracting data/using COUNTIFS

[Addatone]

Hello Experts,

I need some assistance in creating an advanced formula that extracts th
count of data from a spreadsheet using 2 criteria.

I tried this =(INDEX('9008 Data'!A5:A20,MATCH(1,IF('900
Data'!B5:B20='Assessment Summary Report'!B18,IF('900
Data'!D520='Assessment Summary Report'!J16,1)),0))) but it onl
returned the first cell with the Pat id number and not the count.
tried this formula too: =INDEX('9008 Data'!A5:A20,MATCH('Assessmen
Summary Report'!J16&'Assessment Summary Report'!B18,'900
Data'!F5:F20&'9008 Data'!D520,0)) and got the same result.

I attached a copy of the file.

Using the Month and Reference Category (Program) as my criteria, I wil
like to know the count of the patients (using the pat ID) to determin
the number of Patients offered therapy every month.

I also created a drop down menu in the Month cell so that when I selec
February for instance; the count of patients offered therapy for eac
program should populate in the respective cells.

Please help.

I hope to hear back soon. Thank you in advance for your anticipate
assistance.

Addatone

+-------------------------------------------------------------------
|Filename: ExtractdataCountIFs.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=907
+-------------------------------------------------------------------

 

[Claus Busch]

Hi Addatone,

Am Mon, 26 Aug 2013 23:10:28 +0100 schrieb Addatone:

I attached a copy of the file.

your attached file doesn't work. It gives an error when trying to open.

Try:
=COUNTIFS(Data!B2:B20,B18,Data!D220,J16)


Regards
Claus B.

 

[Addatone]

Thank you Claus Busch!

I tested the formula and it works perfectly. Thank you so much for you
help. I truly appreciate it.

Addatone.

Hi Addatone,

Am Mon, 26 Aug 2013 23:10:28 +0100 schrieb Addatone:
-

your attached file doesn't work. It gives an error when trying to open.

Try:
=COUNTIFS(Data!B2:B20,B18,Data!D220,J16)


Regards
Claus B.

+-------------------------------------------------------------------
+-------------------------------------------------------------------