CountIf problems
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: CountIf problems

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a problem and need some help. I have three columns that have demographic information that I need to count in several different ways.
    Example:
    Column A: Age
    Column B: Sex
    Column C: Race

    I want to find how many kids of an age range that at male or female and what race. Does that make sense?
    I want to know how many 6 year old male caucasians there are.(That is just an example) I will change the criteria as needed.
    Thanks so much for your help.

    Jerry

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    It sounds like your data is crying out for a Pivot table rather than a bunch of countif formulae?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I do that?

    Jerry

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-10 09:35, jlbecker67 wrote:
    How do I do that?

    Jerry
    See the Excel Help Index topic for "Create a PivotTable".

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    There's loads you can do with pivot tables and I'll admit I'm not an expert by any means on this.

    Simple way to start to learn, would be to select the table holding your data, go to Tools>Pivot tables on the menus.
    Then go through the wizard, telling it you want to create a pivot table in your existing worksheet with the data you've already selected.
    This finishes you up with a empty table, and a toolbar with your column headings in it.
    Drag one of your headings to the row element, another to the column and see what you get. You can then format it to count up the items in the body of the table or whatever.
    Have a play and see how you get on.

    Rgds
    AJ

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com