Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
79% Doesn't like Me
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. Total Percent Percentile Range Q1 Q2 Q3 Q4 Exemplary 93% or above 4 1 Advanced 87%-92% 7 1 Proficient 80%-86% 1 0 Basic 68%-79% 2 3 Unsatisfactory 67% & below 5 13 Total Tested 19 18 {=SUM(($AC$6:$AC$36=68%)*($AC$6:$AC$36<=79%))} Thanks, Todd -- Tobro88 ------------------------------------------------------------------------ Tobro88's Profile: http://www.excelforum.com/member.php...o&userid=28895 View this thread: http://www.excelforum.com/showthread...hreadid=491225 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
79% Doesn't like Me
Try:
=SUMPRODUCT(--($AC$6:$AC$36=68%),--($AC$6:$AC$36<80%)) so that if a value is calculated as 79.0001%, but displayed as 79%, it will be included. In article , Tobro88 wrote: 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. Total Percent Percentile Range Q1 Q2 Q3 Q4 Exemplary 93% or above 4 1 Advanced 87%-92% 7 1 Proficient 80%-86% 1 0 Basic 68%-79% 2 3 Unsatisfactory 67% & below 5 13 Total Tested 19 18 {=SUM(($AC$6:$AC$36=68%)*($AC$6:$AC$36<=79%))} Thanks, Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|