T
Tobro88
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 |
+-------------------------------------------------------------------+
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 |
+-------------------------------------------------------------------+