what formulas would i use to get and accurate average from a column? we
will say column c20:c31. I would like to skip any value that is not
greater then zero.

ex: 25 I would like that range to show an average of 75... What i
am
125 getting is 30..
0
0 ps- the zero's will change later to actual values so i
would like to
0 formulas to count them if they change from 0 to a number.


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521051