How to use functions after sorting a range?
 

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.

How to use functions after sorting a range?
 

=AVERAGE(A1:A100)
=STDEV(A1:A100)
=MEDIAN(A1:A100)

"R13" wrote:

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.

How to use functions after sorting a range?
 

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

"Teethless mama" wrote:

=AVERAGE(A1:A100)
=STDEV(A1:A100)
=MEDIAN(A1:A100)

"R13" wrote:

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.