Average (exclude 0) First:Last help

[indiemusicboy]

I am trying to average a single cell across multiple worksheets between First and Last tabs. The current formula, =AVERAGE(First:Last!G116), works but it is taking into account "0" values. I want the formula to omit the cells that are zero. However =AVERAGEIF(First:Last!G116,"<>0") returns an error. Any ideas?

 

[indiemusicboy]

Nevermind. I think I figured it out? Spot check me but I think this will work.

=SUM(First:Last!G116)/INDEX(FREQUENCY(First:Last!G116,0),2)