Need Subtotal Help

  • Thread starter Thread starter Coffeeman
  • Start date Start date
C

Coffeeman

Help..

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

What to do?

Thanks
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Intercept and Slope of visible rows, please. 0
Another SUMPRODUCT SUBTOTAL question... 7
Need array formula to ignore hidden values 1
Sumproduct Ignore Text 2
Ignore zero in subtotal formula 2
autofilter average without zero 2
Nesting SUBTOTAL with SUMPRODUCT? 0

Back
Top