Get average of non-zero cells

[shaju]

Hi,
I have 6 cells into which any number (including zero) can be entered. What I want is the average of these 6 cells where the entered value is >0.
ie, if the values entered are - 38,40,0,0,0,0 - into each cells, then the average must be 39, which is the average of non-zero cells. How can this problem addressed.?

 

[oldbrewer]

23
0
27				find the average of the non zero numbers
0
0
0				25
25
0				formula
0				=SUM(A1:A10)/COUNTIF(A1:A10,"<>0")
0

<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[MARZIOTULLIO]

<tbody>
</tbody>

	A​	B​
1​	38​
2​	40​
3​	0​
4​	0​
5​	0​
6​
7​
8​	39​	average

<tbody>
</tbody>

a8=AVERAGEIF(A1:A5,">0",A1:A5)

 

[shaju]

Thanks A Lot dear oldbrewer and MARZIOTULLIO for the quick response. It helped me a lot.

 

[MARZIOTULLIO]

you are welcome