Need Subtotal Help

C

Coffeeman

Help..

I want to ignore all zero values while running the Subtotal average
function on a filtered array.

What to do?

Thanks
 
D

Domenic

Try...

=AVERAGE(IF(SUBTOTAL(9,OFFSET(A2:A100,ROW(A2:A100)-MIN(ROW(A2:A100)),0,1)),A2:A100))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!
 
Top