Unfortunate line breaks try:

="CIC: "&SUMPRODUCT(--(A2:A20=DATE(2008,9,1)),
--(A2:A20<=DATE(2008,9,30)),--(B2:B20="CIC"),--(C2:C20<D2:D20))
&" Improved, "&SUMPRODUCT(--(A2:A20=DATE(2008,9,1)),
--(A2:A20<=DATE(2008,9,30)),--(B2:B20="CIC"),--(C2:C20=D2:D20))
&" Stayed the Same, "&SUMPRODUCT(--(A2:A20=DATE(2008,9,1)),
--(A2:A20<=DATE(2008,9,30)),--(B2:B20="CIC"),--(C2:C20D2:D20))
&" Got worse"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
If I follow you then try:

="CIC:
"&SUMPRODUCT(--(A2:A20=DATE(2008,9,1)),--(A2:A20<=DATE(2008,9,30)),--(B2:B20="CIC"),--(C2:C20<D2:D20))&"
Improved,
"&SUMPRODUCT(--(A2:A20=DATE(2008,9,1)),--(A2:A20<=DATE(2008,9,30)),--(B2:B20="CIC"),--(C2:C20=D2:D20))&"
Stayed the Same,
"&SUMPRODUCT(--(A2:A20=DATE(2008,9,1)),--(A2:A20<=DATE(2008,9,30)),--(B2:B20="CIC"),--(C2:C20D2:D20))&
" Got worse"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dan the Man" wrote in message
...
I received great help on an early formula, and I'm trying to analyze my
data
one other way, and can't seem to think of the best way to write out what
I
need. Here goes an example. Any help would be greatly appreciated:

Disch Program Q #1 Q #1
Date at Admit at Disch

Column A Column B Column C Column D

Sep 1, 08 CIC 5 15
(Improvement)
Sep 15, 08 TP 10 10
(Stayed the Same)
Sep 21, 08 CIC 10 5
(Got Worse)
Sep 22, 08 CIC 5 5
(Stayed the Same)
Sep 22, 08 TP 15 10
(Got Worse)

What I want to compare a improvement, stayed the same, and got worse
within each program. Thus, in the above example, I would look at
Improvement,
stayed the same or got worse for individuals in our CIC program
separately
from individuals in TP or OP. What I want to obtain is a raw score value
that
would tell me:

Of the (3) CIC individuals discharged: 1 Improved, 1 stayed the same, and
1
got worse. I'll do this for the individuals in OP and TP separately, but
once
I get one formula I should be able to figure out the others. HELP, I
can't
wrap my mind around it. I'm grabbling the data off of one sheet
(entitle:
'Raw Data'!), and placing it on another sheet (outcomes). Thus I know I
need
to reference/qualify the raw data sheet using the above string of formula
as
I attempt to generate the information on my outcomes sheet.

Any suggestions? Hope I provided enough information to solve the formula!

Dan