Newbie here - hope you can help
"woodylake" wrote:
I have a column of ages in my club
[....]
About 150 members, I want to find out how many are
1) under30
2)30 to 40
3)40 to 50
4)50 to 60
5)older
Suppose your data are in A2:A151, and your labels above are in B1:B5 [1].
Then select C1:C5 and array-enter the following formula (press
ctrl+shift+Enter instead of just Enter):
=FREQUENCY(A2:A151,{29,39,49,60})
-----
[1] I think the labels should be
under 30
30 to 39
40 to 49
50 to 60
over 60
The point is: having both 30 to 40 and 40 to 50, for example, is ambiguous.
Where does 40 really fall?
|