Age Band Formula

**newbie13** · 05-01-2008, 10:13 AM

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** · 05-01-2008, 10:20 AM

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** · 05-01-2008, 10:23 AM

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** · 05-01-2008, 10:42 AM

Try something like:

=LOOKUP(F2,{0,18,25,35,45},{"under 18","18-24","25-34","35-44","45 and over"})

**newbie13** · 05-01-2008, 10:48 AM

Thank you v.much dude.

You are a genius.

Age Band Formula

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Age Band Formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions