Re: 79% Doesn't like Me
- From: "Sandy Mann" <sandymann2@xxxxxxxxxxxxxx>
- Date: Tue, 6 Dec 2005 22:47:11 -0000
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
sandymann@xxxxxxxxxxxxxx
Replace@mailinator with @tiscali.co.uk
"Tobro88" <Tobro88.1zn1gz_1133905506.2835@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Tobro88.1zn1gz_1133905506.2835@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=28895
> View this thread: http://www.excelforum.com/showthread.php?threadid=491225
>
.
- References:
- 79% Doesn't like Me
- From: Tobro88
- 79% Doesn't like Me
- Prev by Date: Re: Deleting cells with repeated data
- Next by Date: Re: Function for generating monthly & weekly averages
- Previous by thread: 79% Doesn't like Me
- Next by thread: Re: 79% Doesn't like Me
- Index(es):
Relevant Pages
|
