Try this:

=SUM(G:G)/COUNTIF(G:G, "<0")

This sums the entire column, but only divides it by the non-zero
cells, thus giving a true average.

Thanks,
Rachel Garrett