A1:A20 = age (as an integer)
C1 = 30
D1 = 39

=INDEX(FREQUENCY(A$1:A$20,C1:D1-{1,0}),2)

--
Biff
Microsoft Excel MVP


wrote in message
...
Sandy

SUMPRODUCT is a pretty powerful function and I continue to find new
uses for it; but, it seems like the FREQUENCY function was pretty much
made for your situation. You might want to break out the old English-
Danish dictionary and see if that function will work for you.

Good luck.

Ken
Norfolk, Va

On May 7, 3:12 pm, LEG wrote:
Hi - thanks for responding, but as I do know the Danish word for "floor",
I
can't figure out what it means when put together with the formula
"sumproduct" and what it should do. And neither does the Danish help
program!
But I did use a sumproduct formula which worked.
--
LEG

"Sandy Mann" skrev:



Another option:

=SUMPRODUCT(--(FLOOR(H2:H200,10)=30))

etc.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"LEG" wrote in message
...
Hi! I'm looking for at forumla to count how many are in a certain age
group.
I have a list of people and their ages and would like to know how many
are
in
the age group f.eks. between the ages of 30 and 39, 40 and 49 and so
on
--
LEG- Hide quoted text -

- Show quoted text -