Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array issues
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array issues
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel array formulas | Excel Discussion (Misc queries) | |||
Pass an array to Rank | Excel Worksheet Functions | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |