Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Vermilion, Ohio, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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
  •