conditional arrays

[eriqnoodle]

I am calculating a mean and median for an array of data that has an autofilter.

MEAN:
=SUBTOTAL(101,Y9:Y328)

MEDIAN: (array - crtl, shift, enter)
=MEDIAN(IF(SUBTOTAL(3,OFFSET(Y9:Y328,ROW(Y9:Y328)-MIN(ROW(Y9:Y328)),,1)),Y9:Y328))

this works very well. however, in the table, one column (G9:G328) has some rows for which the value is "0". I'd like both of the functions above, (mean and median) to exclude these rows.

any ways to go about this?

 

[Andrew Poulsom]

Why don't you autofilter that column for non zero (after your first autofilter)?

 

[eriqnoodle]

that was too easy i was so intent on finding a way for it to work, i simply neglected to step back and find an easier way.

txs