I have a spreadsheet that I'm using to record statistics. I grab those
statistics from another sheet entitled "Raw Data". The following fomula
provides me with raw score data for all outcomes in Column V that are 91% or
greater:

=SUMPRODUCT(--('Raw Data'!A4:A500=DATE(2008,1,1)),--('Raw
Data'!A4:A500<=DATE(2008,12,31)),--( 'Raw Data'!V4:V500=91%))

The problem I am having is obtaining the raw score data for other percentage
range breakdowns: 71 to 90%, 51 to 70%, 31 to 50%, 11 to 30%, and 0 to 10%.

If someone could kindly provide me with one sample (e.g. 71 to 90%) I think
I could take it from there. The formula I tried (without success) was:

=SUMPRODUCT(--('Raw Data'!A4:A500=DATE(2008,1,1)),--('Raw
Data'!A4:A500<=DATE(2008,12,31)),--('Raw Data'!V4:V500=71%))--('Raw
Data'!V4:V500<=90%)

The formula didn't produce an error, but when I went to test it, I did not
get the correct results. Currently I have one score at 97%, and this is
accurately identified (per the first formula above). However I do NOT have
any scores between 71 to 90%, but the second formula above tells me that I
have "1" outcome in this range. As such I know that the formula I wrote isn't
reflecting the information correctly, because the correct outcome should be
"0", and not "1". Any help would be appreciated.

Thanks much,

Dan