EXCEL 2010, Can I Return a Blank when its Blank acrossed workbooks instead of a zero?

Please Help!!

Can I please Return a Blank when its a Blank when pulling from a seperate workbook instead of a zero in Excel 2010?

I already know that I can un click in Options, Advanced and turn off "Show a Zero in cell that have zero value." The issue with this is that It still calculates if it hides the zero. I just need the cell to create Blank and not create a hidden "Zero"

This is a real Cell Pull Example:

{='C:\Users\CntrlRm\Desktop\Treatment Plant Testing and Record Keeping\2011\9 September\[Day 1.xlsx]Daily Water Testing'!$C$21}


Thanks in Advance for your help!!

I am trying to avoid averaging and calculating zeroes outside of parameters. Otherwise I wouldnt care. Most cases real life scenarios i wont pull a test at a zero. But because I may have a parameter that is usually between a .3251 and a .3451, I am calculating any tests that are outside these numbers.

Thanks so much for your help, it did pull a blank for me.

CRUSROD

Originally Posted by tlafferty

=IF(='C:\Users\CntrlRm\Desktop\Treatment Plant Testing and Record Keeping\2011\9 September\[Day 1.xlsx]Daily Water Testing'!$C$21=0,"",'C:\Users\CntrlRm\Desktop\Treatment Plant Testing and Record Keeping\2011\9 September\[Day 1.xlsx]Daily Water Testing'!$C$21)

The issue with this is that it will put a blank string into your workbook. If you are trying to avoid averaging in zeroes, for example, there are ways around this.

Now your answer worked form me in multiple occations, now I have about 8000 different seperate calculations that would need changed to implement this to work properly or Can I change this AVERAGE Calculation on the bottom to not read the ZERO's comming from the blanks in the other workbooks?

This calculation I have works but it still calculates the Zero.

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

This calculation is what I am trying to do to get rid of not counting the zero but I think I am going about it wrong, and it gives me an error.

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

Do you think I should Start a new thread on this?

Thanks for your help.

---------- Post added at 10:17 AM ---------- Previous post was at 09:44 AM ----------

I have also asked the NEW question at this new thread with my attachment.

http://www.excelforum.com/excel-form...html?p=2867871

Thank you all for any help in advanced.

Rod

Bump Thank you in advance!!