Need Subtotal Help

[Coffeeman]

Help..

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

What to do?

Thanks

[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!

Help..

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

What to do?

Thanks