Maybe...

=sum(a1:a6) / countif(a1:a6,"<"&0)

Peter wrote:

I need to find out how to have the average not count the 0's...
A1 12
A2 0
A3 12
A4 12
A5 0
A6 0
using =average the average is 6. I need the =avaerage not to count the zeos
and the average to be 12.

--

Dave Peterson