I need to use functions like mean, median, mode, standard deviation, etc,
after I apply different filters to a sheet. Whenever I try to use functions
it includes the values excluded by the filter (as if event though the cells
were hidden, they were still used in the calculations). How do I apply a
filter then use a function like mean median and mode to only work on the
values visible?