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