averages

[JGarza]

I have a list of of numerals and some are zero, I need an averaqe of only those cells that have a numberal greater than 0.

So lets say I have 3,2,0,5,4,0,0. Averaging in Excel will give me 2. But the answer I want is 3.5. I don't want it to consider the zeros.

 

[Juan Pablo González]

Try with this array formula

=AVERAGE(IF(A1:A10,A1:A10))

 

[lenze]

Also, see this thread

http://www.mrexcel.com/board/viewtopic.php?topic=9885&forum=2