# Thread: counting (Office 2003 SP2)

1. ## counting (Office 2003 SP2)

i have ages from 18 to 46 and over in a row randomly. i need to get the number of ages from 18 to 25 i.e 5 are in the 18 to 25 age bracket, the number that are in the 26 - 35 age bracket. etc. i don't need to add or average. i just need to find how many in that row meet the criteria of 18-25, 26-35, 36-45, etc.
Thanks for any help.
Craig R. Caire.

craigc@compass-house.org. This is my work e-mail. this is where i need the information.

2. ## Re: counting (Office 2003 SP2)

You can use the FREQUENCY function for this:
Let's say the ages are in A2:A55.
Create a table with the upper limits of the age brackets (except for the last one). Let's say 25 is in E2, 35 in E3, etc., up to 65 in E6.
Select F2:F7 (i.e. one cell more than in column E).
Enter the formula =FREQUENCY(A2:A55,E2:E6) and confirm it with Ctrl+Shift+Enter to make it an array formula.

See attached version.

3. ## Re: counting (Office 2003 SP2)

You can use the countif function:

=COUNTIF(\$A2:\$E2,">=18")-COUNTIF(\$A2:\$E2,">=26")
=COUNTIF(\$A2:\$E2,">=26")-COUNTIF(\$A2:\$E2,">=36")

etc. Change the ranges as desired. If you put the starting value in the first row, you can reference this value and copy it:
=COUNTIF(\$A2:\$E2,">="&F\$1)-COUNTIF(\$A2:\$E2,">="&G\$1)

Steve

4. ## Re: counting (Office 2003 SP2)

BTW, we always post replies in the thread itself. In Edit email notifications, you can specify that all replies to posts by you will also be e-mailed to the "real" e-mail address in your profile.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•