in excel, how do i get an average without including the zeros?
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.
|