Column E Column H Column Y
Program # of Repeat Svs Completion Status

IOP 2 Completed
OP 1 ASA
CIC 0 Admin Disc
TP 4 Completed
IOP 3 Completed
IOP 2 ASA

In the above example, I want to look at home many times an individual in a
particular program (Column E), has returned for services (Column H). I am
also looking at the individuals completion status (Column Y). Using the
example above, I should be obtaining the following outcomes:

I am also looking at particular dates of service (which the formula below
includes). Unforuntaely, the formula I have written doesn't accurately
reflect the column H information I desire. The current formula only tells me
how many occurances greater than 0, and indivdual has had repeat services. In
order words, it would tell me that In our IOP Program, (3) people had repeat
services (only counting the "occurance" of repeat services, and not the
actual "summing" of the number of times an individual has returned for
services.

I had also not included the Column Y parameter which looks at the
individuals "completion" status, and was having difficulty encorporating that
informtion into my formaula............Any help would be appreciated. The
formula below is what I currently have, but obviously I need to modify and
expand this formula in order to get what I want.....................MUCH
THANKS in Advance, Dan

=SUMPRODUCT(--('Raw Data'!$X$4:$X$5000=DATE(2008,4,1)),--('Raw
Data'!$X$4:$X$5000<=DATE(2008,6,30)),--('Raw Data'!$H$4:$H$50000),--('Raw
Data'!$E$4:$E$5000="IOP"))