79% Doesn't like Me

  • Thread starter Thread starter Tobro88
  • Start date Start date
T

Tobro88

This is very odd to me. I am using the following array. Every singl
formula on the sheet works fine except for this one. The formula i
not recognizing the actual percentage 79%. The formula will count 80
and 78%, but the fields that actually fall on 79% are not bein
counted. Do you think that this would have something to do with the A
and beyond range? The identical formula seems to work ok in the A-
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,
Tod
 
Your formula works for me. Are you sure that it is not a rounding issue
with what is being diplayed as 79% actually being 79.1% or larger.

Incidentally if you replace the SUM with SUMPRODUCT youwould not have to
array enter the formula.

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
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.
 
Back
Top