Results 1 to 7 of 7

Thread: countif (2003)

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    countif (2003)

    13 columns, 10 rows. Column A contains names, with duplications. Columns B-M, scores, for each of the twelve months. Each name may or may not have a score for each month (i. e., John may have 4 scores in January, but none in February, 2 in March, etc.). I would like to count the number of scores in each column that is associated with each name. Any help?
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: countif (2003)

    Do you have a list of unique names somewhere?

    (Why don't you attach a sample workbook?)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: countif (2003)

    If you already have a list of unique (non-duplicated) names, you can use a SUMPRODUCT formula as in the attached sample workbook.
    Attached Files Attached Files

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: countif (2003)

    No, I am afraid they are not unique.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: countif (2003)

    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: countif (2003)

    I suspect you could use a pivot table but it would be helpful, as Hans said, to see a sample.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: countif (2003)

    Hans,
    This worked for what I wanted to do!
    Thanks.

Posting Permissions

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