Hello,

I want to calculate the average value of a large range of cells in a
column. The snag is that many of the cells are blank, or contain text. I
only want to average those which contain a number, (they are positioned
irregulary & unpredicatbly down the column).

Can someone help me with a formula to do it please ?

Thanks

K