Forum Discussion
Determining the average and median of a filtered column of numbers
I want to be able to determine various statistics, e.g., sum, average, median, standard deviation, etc., for a filtered column of data. For example, assume I had a column of 6 data entries,
1
...
Hi Matt,
Referring to SergeiBaklan's reply, the SUBTOTAL function includes some of the statistical functions, but doesn't include the median!
So please take a look at this function instead: AGGREGATE, it provides you with a various range of statistical functions, and you have the option to apply them to the visible cells only.
Please find the attached file to test it.
Hope that helps
