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
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