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