Thread: Average
View Single Post
  #2  
Old August 19th, 2004, 09:21 PM
Jason Morin
external usenet poster
 
Posts: n/a
Default

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"))
.