How to use functions after sorting a range?

R

R13

I would like to use functions to get values of columns that have numbers in
them after sorting them. For example, after sorting, I would like to find
the average, standard deviation or mean for the numbers in the column.
Please advise how to do this.

Currently, my method includes all cells in the range, not just the sorted
ones.
 
R

R13

My mistake. I meant filter not sort. I want to use these same functions with
filtered data. Thanks for the reply nonetheless.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top