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