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