I have a column of ages in my club on a spraedsheet like
AGE
21
32
45
55
50
45
19
32
etc
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

for the answers to come out in anither column, whats the formulae i have to use please