Help..

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

What to do?

Thanks


--
Coffeeman
------------------------------------------------------------------------
Coffeeman's Profile: http://www.excelforum.com/member.php...o&userid=25259
View this thread: http://www.excelforum.com/showthread...hreadid=387504

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!

Coffeeman Wrote:
Help..

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

What to do?

Thanks


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=387504