jmiskey said:Actually, if negatives are a possibility and you want to ignore zeroes, you would want to modify DRJ's response a little:
=SUM(A:A)/COUNTIF(A:A,"<>0")
Otherwise a negative value could hose the average since it would be included in the SUM portion, but not in the COUNTIF portion.
If the cells are truly blank the Average() formula will overlook them.