Results 1 to 4 of 4

Formula to count names

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2011
    Location
    Waynesburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Formula to count names

    I searched the forums but haven't found an answer that works for me. I'm trying to count the number of times a name appears in a column.

    A1 - Tom
    A2 - Tom, Harry
    A3 - Joe, Tom
    A4 - Tom
    A5 - Tom, Bill

    I want to count Tom in the list.

    I've tried =countif(A1:A5,"Tom") which give the answer of 2.

    On another forum I found this one =SUMPRODUCT(--(COUNTIF(OFFSET(A1:CH1,ROW(A1:A5)-ROW(A1),),"Tom")>0)) also gave me the answer 2.

    Ideas??
    Last edited by jdepriest; 09-09-2011 at 01:29 PM.

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