Try:

=SUMPRODUCT(--($AC$6:$AC$36=68%),--($AC$6:$AC$36<80%))

so that if a value is calculated as 79.0001%, but displayed as 79%, it
will be included.


In article ,
Tobro88 wrote:

This is very odd to me. I am using the following array. Every single
formula on the sheet works fine except for this one. The formula is
not recognizing the actual percentage 79%. The formula will count 80%
and 78%, but the fields that actually fall on 79% are not being
counted. Do you think that this would have something to do with the AA
and beyond range? The identical formula seems to work ok in the A-Z
columns.



Total Percent
Percentile Range Q1 Q2 Q3 Q4
Exemplary 93% or above 4 1
Advanced 87%-92% 7 1
Proficient 80%-86% 1 0
Basic 68%-79% 2 3
Unsatisfactory 67% & below 5 13
Total Tested 19 18



{=SUM(($AC$6:$AC$36=68%)*($AC$6:$AC$36<=79%))}


Thanks,
Todd