Averaging without counting the 0s.
The cells with 0 are your problem. The blank ones do not affect the average or count functions. If the 0 entries must be maintained, I would suggest a hidden column. In the hidden column use a formula, IF(a1=0,"",a1). Fill this down for the number or rows...