79% Doesn't like Me
 

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


--
Tobro88
------------------------------------------------------------------------
Tobro88's Profile: http://www.excelforum.com/member.php...o&userid=28895
View this thread: http://www.excelforum.com/showthread...hreadid=491225

79% Doesn't like Me
 

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

Replace@mailinator with @tiscali.co.uk


"Tobro88" wrote in
message ...

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


--
Tobro88
------------------------------------------------------------------------
Tobro88's Profile:
http://www.excelforum.com/member.php...o&userid=28895
View this thread: http://www.excelforum.com/showthread...hreadid=491225

79% Doesn't like Me
 

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