Steve:
does this work for you?
=SUMIF(A2:A5,"<0")/COUNTIF(A2:A5,"<0")

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Steve" wrote:

I am looking to write an AVG function that doesn't count
cells with zero's in it. The information is all in one
column. Some cells just habve no info. Can anyone help?


Thanks,
Steve