Average Outside of Parameters not to count a Zero as well.

I am having issues with this Attached Excel 2010 Workbook, Sheet, "Influent" C40 and the coppied statement below as well. As you can see its says I am 100% outside of parameters in this column because its counting the zero's of non entered future cells as of yet. This should say 0% while everything is empty. But because I am pulling Blank cells from another workbook that are empty as of now, it pulling zero's in every cell, about 8000 cells.
Can I just change this formula a bit to not count zeros as well as the parameters I set in C7 and C8. Or Do I have to change every single cells formula as "Tlafferty" explains at this thread? http://www.excelforum.com/excel-gene...html?p=2867816 Ps, I created a new thread as its a new question.


=IF(COUNT(C8:C38)=0,"",SUM(COUNTIF(C8:C38,"<="&C6-0.0001),COUNTIF(C8:C38,">="&C7+0.00001))/100*3.2258064)


I apreciate everyones help in advance.

Thank you,

CrusRod

Bump? Thank you in Advance

---------- Post added at 03:50 PM ---------- Previous post was at 01:01 PM ----------

53 Views for this thread, obviously people searching for some kind of answer similar to this. I hope someone has some expertise in this area. Thanks again

Originally Posted by shg

Maybe ...

=3.2258064 * (COUNTIFS(C8:C38, "<>0", C8:C38, "<=" & C6 - 0.0001) + COUNTIFS(C8:C38, "<>0", C8:C38, "<=" & C7 + 0.00001))/100

Thanks for your help, this calculation got rid of calculating zero's but now it will now not calculate my %'s outside of Parameters (Range) from C6 & C7, If you have a clue on keeping that in spec with your equastion please let me know. I been messing with it for an hour and a half and can only get one side of the Range C6 to calculate but not C7.

Just manually put in some data, in a few cells, ignore the workbook its pulling from. The data that is entered is very close to the range set in C6 & C7. Right now Range is set to be between 10 and 12 any # outside of this would be considered outside of parameters which will tell you or populate your % outside parameters on the bottom in cell C40 . In days 1-5 manuly enter data, put a # 8,9 10,11,14 or whatever, try higher than range, than lower the range set. I can only now get lower than range to work with your equation with minor editing. If your within range you should not get a higher %, if you put in high or low your # for each day C4 should increase by 3.23% each day outside of the range set.

Thanks a bunch for your help and replies.
I hope this thread will help others looking at similar situations.
Currently at 76 views before we are solved. Thanks

Bump; Anyone please help? Thanks