Quartile Function - Not hidden rows

[BNL]

I'm working on a spreadsheet that computes a number of statistical results, including quartile functions. I want to be able to filter the rows and use only the rows that are NOT hidden within the calculations.

I would typically use the SUBTOTAL function, but it does not include the quartile function in it's options.

Is there any way to figure quartile calculations on only non-hidden rows?

Thanks!

Barry

 

[XOR LX]

You're welcome!

Regards