Count age range formula

[cpope]

I have a 2007 spreadsheet where a person's age is entered into a cell. I need to count how many are between 26-30, 31-35, 36-40, etc. Please tell me what formula I should use? Thanks.

[DonkeyOte]

One route given use of 2007 would be to use COUNTIFS

=COUNTIFS($A$2:$A$100,">=26",$A$2:$A$100,"<31")

You could also consider using a Pivot Table ...

Assuming Ages are in Column A (header Age in A1) ... go to Insert -> Pivot Table -> highlight your data...

Then:

Set Age as Row Label

Set Age as Data Field set to COUNT (ie using field twice over)

Now Right click on any Age value and select Group ...
Set Min to be the lowest age you're interested in (ie lowest boundary - eg 26)
Set Max to be the highest boundary point you're interest in (eg 80)
Set Interval (eg 5)

[cpope]

Thank you!