Why don't you calculate the average yourself ie:-

=SUM(A1:A10)/COUNTIF(A1:A10,"0")
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Gudmundur" wrote:

I am using the average function in a large documents for different time
periods. Some time periods have ZERO, which bias the average.

Can I use the average function but not have it count zeros in the total?