Average a selection of cells where some contain #DIV/0!

Hi

I have a column of cells that I want to average, but some of them contain #DIV/0! (this is expected because there's no data available for that particular row). Is there any way I can average but excluding those cells?

Thanks

If the data is in the range a1:a40, enter the following as an array (holding down shift and control when you press enter)

=AVERAGE(IF(ISERROR(a1:a40),"",a1:a40))

Is that what you require

Regards

Dav

perfect - thanks!