Array issues
 

I thought that it was better to send the sheet to explain things.


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.


I have included the sheet for review.

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


Thanks,
Todd


+-------------------------------------------------------------------+
|Filename: todd 01.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4103 |
+-------------------------------------------------------------------+

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

Array issues
 

That is because the 79% is actually 79.17%, the format makes it look =79%,
but it isn't.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tobro88" wrote in
message ...

I thought that it was better to send the sheet to explain things.


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.


I have included the sheet for review.

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


Thanks,
Todd


+-------------------------------------------------------------------+
|Filename: todd 01.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4103 |
+-------------------------------------------------------------------+

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