Forum Discussion
Matt Lind
Mar 24, 2018Copper Contributor
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
...
SergeiBaklan
Mar 24, 2018MVP
Hi Matt,
You may use SUBTOTAL function which ignores filtered cells.