Ignoring hidden rows in PERCENTILE function
 

Hello,

I'm trying to summarize results of autofiltered content. I've used the
subtotal function to provide average, min, max, and count - but I also need
to provide 25th and 75th percentile values, which can not be calculated with
subtotal.

So, I need to use the =PERCENTILE function but only apply it to visible
cells. I'm not good enough with vba to write something to make this happen.
:\

If you can help and have the time, I'd be grateful.

Thanks!

Brad