I have a feeling the order of my formula is out of order....HELP!

D

Dan the Man

I have this formula that just isn't working right. I am looking for the
number of individulas who fall between specific percentage ranges of
improvement in our various programs. I have broken down improvement using
the parameters identified in Column A. The raw score outcomes are generated
in Column B.

Column A Column B

91% plus 249
71 to 90% 101
51 to 70% 90
31 to 50% 90
11 to 30% 19
0-10% 1

Total= 550

In our CIC program (the program used in the forumla example below) we have
86 total clients who demonstrated some level of improvement. However, when
addiing up the totals (from the outcomes produced in Column B), I get a final
raw score of 550, which can't be right, given that the total number of
individuals who improved in this program was only 86. A sample of my formula
is:

=SUMPRODUCT(--('Raw Data'!$X$4:$X$5000>=DATE(2007,7,1)),--('Raw
Data'!$X$4:$X$5000<=DATE(2008,12,31)),--('Raw
Data'!$E$4:$E$5000="CIC")--('Raw Data'!$W$4:$W$5000>=71%),--('Raw
Data'!$W$4:$W$5000<=90.99%))

Any help would be greatly appreciated?
Thanks very much,

Dan
 
D

Dan the Man

Thank you..........I feel so silly when I'm missing something as small as a
"comma"..........It's been a long day, lol!

smartin said:
Dan the Man wrote:

[snipped]
=SUMPRODUCT(--('Raw Data'!$X$4:$X$5000>=DATE(2007,7,1)),--('Raw
Data'!$X$4:$X$5000<=DATE(2008,12,31)),--('Raw
Data'!$E$4:$E$5000="CIC")--('Raw Data'!$W$4:$W$5000>=71%),--('Raw
Data'!$W$4:$W$5000<=90.99%))

Hi Dan,

Are you missing a comma?

=SUMPRODUCT(--('Raw Data'!$X$4:$X$5000>=DATE(2007,7,1)),--('Raw
Data'!$X$4:$X$5000<=DATE(2008,12,31)),--('Raw
Data'!$E$4:$E$5000="CIC")
,
--('Raw Data'!$W$4:$W$5000>=71%),--('Raw
Data'!$W$4:$W$5000<=90.99%))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top