Average select cells in a column and ignore 0

[tbrynard01]

Have a sheet with multiple rows and would like to average only certain lines not the entire column and want to ignore 0's in cells in my range:
A1
A2
A3
A4
A5

Want to average for example only A1, A3 and A5 and ignore it if the value is zerio


Thank you

 

[Joe4]

Two ways:

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

or

=SUM(A1:A5)/COUNTIF(A1:A5,">0")

The AVERAGEIF function was added with Excel 2010.

 

[tbrynard01]

Thanks I figured it out