Choosing numbers

Closed
jake - Feb 7, 2010 at 11:25 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 7, 2010 at 07:25 PM
Hello,
I would like to choose numbers above a certain value from a group of numbers, and then average those numbers. Any advice?
Thanks

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 7, 2010 at 07:25 PM
suppose your data sheet from A1 to AQ10 is like this

1
8
10
3
6
10
2
5
8
1

suppose you want to find out the average of these numbers more than 3.
in an empty cell type or copy paste this formula

=AVERAGE(IF(A1:A10>3,A1:A10))

INVOKE THIS FORMULA BY HITTING CONTROL+SHIFT+ENTER

use this for your data. it is NOT necessary for the data to be sorted.
0