Hazarding a guess that a pivot table is quite ideal
for what you seek to do. It's easy n fast to set-up

Here's the play to tinker with (steps in xl2003):
Presume that you have age data (as posted) in col A,
with col header: Age (in A1), data from A2 down, viz:

Age
50-<70
50-<70
17 <30
30-<50
70+
17 <30
etc

Select any cell in the table, click Data Pivot table ..
Click Next Next. In step 3, click Layout, then just:
Drag n drop Age into ROW & DATA area
Click OK Finish

Hop over to the pivot sheet (new sheet just to the left of your data sheet)
The pivot will return the uniques listing of the various items that's in the
Age source col (eg: 17 <30, 50-<70, etc) and the corresponding counts of each
next to it.

And if you want the counts expressed as percentages (of total in col)
Double-click on "Count of Age".
In the dialog: Click Options, then
Under "Show data as:", choose: % of column OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Call me Ana, Ana Pego" wrote:
I am trying to do this operation:
in cell F7 I have the following datas corresponding to peoples age
how can I count the numbers of time its ocurrs eg. of 50-<70

50-<70
50-<70
17 <30
30-<50
70+
17 <30
I also need to know the percentage of each of them,
how often they have been in that cell