Average only columns with data

Hi All:

I have twelve columns of data nine of which are filled. I'm trying to come up with a formula that averages a column only if it has data in it, I have attached a sample file. As I add data the average should change without changing the formula..

Once again, thanks for everyone's help in advance...

Max