Look for a count of numbers to be bigger than 0.

=IF(SUBTOTAL(2,A2:A10)=0,"",SUBTOTAL(1,A2:A10))

Neil Berkowitz wrote:

What is the easiest way to division by zero errors that occur when using
automated subtotals to display averages?

--

Dave Peterson