Average() excluding zero's

[HPIMICHAEL02]

good day

im trying to average a row of cells that have a formula in them and they return 0.00 while i need to exclude these cells so i get a true average of the cells that are not zero.

thanks in advance.

[hemesh]

Try this
SUM(range)/COUNTIF(range,"<>0")

[martindwilson]

Use averageif()
=avarageif(a1:a10,"<>0")

[Ghozi Alkatiri]

=sum(a1:a10)/countif(a1:a10,">0")