Choosing numbers
Closed
jake
-
7 Feb 2010 à 11:25
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 7 Feb 2010 à 19:25
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 7 Feb 2010 à 19:25
Related:
- Choosing numbers
- Hogwarts legacy choosing house - Guide
- Choosing the right graphics card - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
7 Feb 2010 à 19:25
7 Feb 2010 à 19:25
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.
