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