Age Band Formula

[newbie13]

Hi,

Help required.

Looking to calculate the following age bands from a huge list of data;

18 - 24
25 - 34
35 - 44

Have tried most things, but am now stuck.

This should be easy!

Can anyone help?

Please.

[daddylonglegs]

What do you have, dates of birth or ages?

What do you want to do, count how many fall into each category?

If you have ages in F2:F1000, for instance you can count how many fall between 18 and 24 with this formula

=SUMPRODUCT((F2:F1000>=18)*(F2:F1000<=24))

[newbie13]

I have a list of ages. The range is 18 - 40

So would like to band them in the mentioned bands.

Some like =if(F2>=18<=24,"18-24" & so on...


What you have posted has helped. But isn't eactly what I need. But hey, something I've learnt.

Any further help would be appreciated.

newbie13.

[NBVC]

Try something like:

Please Login or Register  to view this content.

[newbie13]

Thank you v.much dude.

You are a genius.