How about:
=SUM(K5:K73)/(COUNT(K5:K73)-COUNTIF(K5:K73,0))
HTH
Jason
Atlanta, GA
-----Original Message-----
I'm trying to average a group of numbers. I do not want
to include the blank or zeros. I used the following to
exclude the zeros but it is still including the blanks.
Thanks for any help you might be able to send me.
=AVERAGE(SUM(K5:K73)/COUNTIF(K5:K73,"0"))
.
|