Thread
:
79% Doesn't like Me
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
Posts: n/a
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
Reply With Quote