use this idea. it must be ARRAY entered with CTRL+SHIFT+ENTER
=AVERAGE(IF(C1:C1000,C1:C100))

--
Don Guillett
SalesAid Software

wrote in 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"))