I haven't found this example in the threads, I hope someone can help me. I need to make the following formula disregard blanks and zeros. Please help.

=IF(COUNT(B10:B62),AVERAGE(B10:B62))

Thanks, Jwest