this formula works an so does Ron's. thank you guys for your help. And i
would not any negative numbers in my calculations, i just set the original
equation up off of the office help and i am not that great with figuring
these things out so i guess i set it up wrong (to answer a question you asked
below). Hopefully i am getting better, with help from this site of couse. :)
thanks again.

"Anne Troy" wrote:

=SUMIF(B1:B6,"0")/COUNTIF(B1:B6,"0")
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Season" wrote in message
...
I am using a formula to include all values greater than zero in my average
which has worked fine until i tried to extend the parameters, then it
gives
me the Value? sign. Does anyone know another way to accomplish what i
want?

here is what i am using now.
=average(if(BZ28:CM28<0, BZ28:CM28, " "))

i was trying to make the CM extend to CS, but for some reason it is not
working. Anyway, i figure a different equation might be better than what
i
have and solve my problem.