+ Reply to Thread
Results 1 to 5 of 5

Need formula to count how many times a specific name is entered in a column

  1. #1
    Registered User
    Join Date
    02-28-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    10

    Need formula to count how many times a specific name is entered in a column

    Thanks in advance for reading my request.

    Ive got a worksheet that Lists champions in a Fantasy fighting league, id like a formula to count how many times a certain fighter has won a specific belt.
    on a seperate worksheet Im counting the number of titles in a statistical breakdown.

    All champions are listed in a single column I.E. Column A

    A2 John Smith
    A3 Jack Sullivan
    A4 Mike Jones
    A5 John Smith
    A6 Tim Owens
    A7 John Smith

    So John Smith has 3 Title wins, I like a formula to show the number 3 in the corresponding cell.

    Thanks again.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Need formula to count how many times a specific name is entered in a column

    In B2 cell

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag it down.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Need formula to count how many times a specific name is entered in a column

    hi JoeBlakkk, try:
    =COUNTIF(A2:A7,"John Smith")

    you can also use a cell reference to replace the red portion.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  4. #4
    Registered User
    Join Date
    02-28-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Need formula to count how many times a specific name is entered in a column

    Thanks for the quick reply guys.
    If I did want to use a cell reference from a different tab (Tab = Title 1, and Cell A4)
    how would I enter it?

    =COUNTIF('Title 1'!B:B,"A4")??
    Doesnt seem to work, although if I type the name directly it does work.

  5. #5
    Registered User
    Join Date
    02-28-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Need formula to count how many times a specific name is entered in a column

    Nevermind I got it.

    Thanks again! it works better than I had hoped.

+ 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