I have a spreadsheet set up with "AutoFilter" so that I
can easily filter for rows that contain specific values.
At the bottom of the spreadsheet is a "Total" row that
uses the "subtotat" function to dynamically update the
totals based on what I sorted by.

My question is how can I also find the median of these
subsets of data? When I use the median formula it insists
on returning the median of all values in the range, not
just the ones showing in the filter.

This is probably a dumb question, but any help would be
appreciated. I found a work around to do sub-averages,
but can't figure out median.

Thanks,

Jim G.