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

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

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. ## Re: Need formula to count how many times a specific name is entered in a column

In B2 cell

Formula:
`Please Login or Register  to view this content.`

Drag it down.

3. ## 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.

4. ## 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. ## 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.

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

#### 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