+ Reply to Thread
Results 1 to 8 of 8

Count names from separate worksheet, and from separate rows

  1. #1
    Registered User
    Join Date
    05-04-2012
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    2010
    Posts
    11

    Count names from separate worksheet, and from separate rows

    I am trying to count how many times a name appears on 5 different rows (3, 12, 21, 30, 39) on a separate worksheet from where I want the actual count to appear. I've tried COUNTIF, COUNTIFA, and SUM functions and nothing seems to be working. What kind of formula do I need for this?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,230

    Re: Count names from separate worksheet, and from separate rows

    Post a workbook for experimentation.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    05-04-2012
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    2010
    Posts
    11

    Re: Count names from separate worksheet, and from separate rows

    And how exactly do I go about doing that? Sorry I'm new to the forums and to Excel.

  4. #4
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: Count names from separate worksheet, and from separate rows

    Assuming that Column A contains the names, maybe...

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Note, however, INDIRECT is a volatile function.

  5. #5
    Registered User
    Join Date
    05-04-2012
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    2010
    Posts
    11

    Re: Count names from separate worksheet, and from separate rows

    I'll try to explain everything as best I can:
    On the first worksheet, called W1, the name I am using for this is in A27, lets name it John. I would like the result of this formula to be input in D27 as just a count of how many times the name appears. The rows I want to count the name in are on a separate worksheet, called W2. They are rows 5, 14, 23, 32, 41.

    If you need any other info, let me know.

  6. #6
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: Count names from separate worksheet, and from separate rows

    Maybe you missed my earlier post. In any case, as per your last post, try...

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.

    Of course, if the name of interest cannot occur between the target rows, the following would suffice...

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    05-04-2012
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    2010
    Posts
    11

    Re: Count names from separate worksheet, and from separate rows

    None of those seem to be working for me. I've tried all 3, as well as the 2 in your earlier post. I'm not entirely sure what is meant by "confirm with Control-Shift-Enter", but I think you just press those 3 buttons down to confirm the formula rather than simply Enter? So far all the formulas just come up with a value of 0, when I know they should be coming up with a value of 2.

    Am I doing something wrong? Or is there a different way I should be doing it?


    EDIT: I lied. Got it working now. I realized that I didn't only have the value I was looking for in the cells I wanted to look for it, so I just made them their own cells. That's what you get for being a novice Excel user. Thanks a ton!
    Last edited by juicestain09; 05-05-2012 at 12:22 PM.

  8. #8
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: Count names from separate worksheet, and from separate rows

    You're very welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1