Excel query on averages

[techno]

Please can someone give some pointers on the formula code I need to get an average of a series of figures in excel...

The key thing is that any blank cells in the series are not counted and used for the average calculations

14 8 0 6 8 10

The above series would be calculated therefore as sum divided by 5 (the zero or blank cell not being counted)

Thanks in advance!!

 

[TFT]

Try
=SUM(A1:A100)/(SUMPRODUCT((A1:A100<>0)*1))

changing the cell letters and range to suit.