Choosing numbers
Closed
jake
-
Feb 7, 2010 at 11:25 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 7, 2010 at 07:25 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 7, 2010 at 07:25 PM
Related:
- Choosing numbers
- Choosing a graphics card - Guide
- Choosing a video card - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 7, 2010 at 07:25 PM
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.
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.
