try this
=( SUM(A1:A6)/ ( COUNT(A1:A6)-COUNTIF(A1:A6,0) ) )
Let me know if your problem is not resolved
--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile:
http://www.excelforum.com/member.php...o&userid=16271
View this thread:
http://www.excelforum.com/showthread...hreadid=276747