I have a column I want to average however it contains zero's and #DIV/0 entries in it. Those entries are from linked sheets that have not been populated and are supposed to be there. I want to average the column that contains these values but want the values excluded from the calculation until they are populated with real numbers.

Anyone have any ideas on how to do this? Thanks in advance for any help you can give.

Steve