Formula to average a column on another sheet excluding "0"

[svtsilversnake]

The title says it all. I need formula to Average the percentages of column G:G on sheet1 in cell a1 of sheet2 excluding all zero's to return a true average.

 

[vogel997]

Try this:
=AVERAGEIFS(Sheet1!G:G,Sheet1!G:G,">0")

 

[VoG]

Maybe

=AVERAGE(IF(Sheet1!G:G<>0,Sheet1!G:G,FALSE))

confirmed with CTRL + Shift + Enter