Hey Rick, thank you for your suggestion. I forgot to mention that the
"Eval-Mand" clients are not tracked for improvement (only those identified as
"Mand" are). Sorry about forgetting that important piece.

Thus the array should be evaluating:

(a) Mandated clients who completed treatment and showed improvement, and

(b) Evaluation mandated clients who merely completed treatment.

When checking the math by hand I know that I have 222 mandated clients who
completed treatment and showed improvement, and 64 evaluation mandated
clients who completed treatment. Thus, my formula should result with a raw
score of 286. Again, I apologize for leaving that piece of critical
information out. I'm a bit of a "space case" today............Dan

"Rick Rothstein" wrote:

On a quick look... that last term is being multiplied by the SUMPRODUCT...
it is not part of it, so the array range it contains is not being evaluated
by it. I think you may want this...

=SUMPRODUCT(--('Raw Data'!$U$4:$U$50000),--('Raw
Data'!$F$4:$F$5000="Mand"),--('Raw Data'!$F$4:$F$5000="Eval-Mand"),--('Raw
Data'!$Y$4:$Y$5000="completed"))

--
Rick (MVP - Excel)


"Dan the Man" wrote in message
...
I need a formula which looks at the following factors: (Column U) clients
who
showed program improvement, (Column F) clients who were mandated to
treatemnt, (Column F) clients who had a mandated evaluaiton, and (Column
Y)
clients who completed treatment. Please note that Column F has a drop down
menu with three options: mand, vol, Eval-Mand. The formula I have below
renders the outcome to be "0", so I know I ham missing something.:

=SUMPRODUCT(--('Raw Data'!$U$4:$U$50000),--('Raw
Data'!$F$4:$F$5000="Mand"),--('Raw Data'!$F$4:$F$5000="Eval-Mand")*('Raw
Data'!$Y$4:$Y$5000="completed")


It may also be helpful to know that I originally had the formula only
looking at improvement for those who were mandated to treatment, and
completted, however I need to add in the additonal factor of those who
were
mandated to have an evaluation. Again, both mandated to treatment, and
mandated to have an evaluation are "drop down" menu items in Column F. Any
help would be greatly appreciated.

Thanks in advance!

Dan