Division by zero in automated subtotals

N

Neil Berkowitz

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

Dave Peterson

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

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