Need Formula for Counting the Number of times Celltext appears in a list of cells

Hello everyone.

I am looking for a formula that I can use to count the number of times an album from an artist appears within a list of 17,450 other cells. I was wondering if there was some sort of SEARCH function I could use and then I could just drag it all the way down the bottom of the page so I do not have to edit anything.

If you look at the image below, I have the first column as the Title which is the title of the album, second as the artist, and the 3rd row as the number of times it appears within my dataset. The data is organized within a time-series format, however, sorting the data will not affect the count.

I would like this Count to be within each cell of the Longevity column. So if you look at the image, under the 'Title' Column there are 10 rows where it says "Louden Up Now". I would like it to say "10" in each cell of the 'Longevity' Column.

Let me know if anyone has any ideas. Thanks!

Screen Shot 2015-06-15 at 8.19.56 PM.png

You have attached an image. That's not very easy to work with. We have to re-type your information before we can begin to address your problem. That will put a lot of people off completely.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Does this get you what you are looking for?

Please Login or Register  to view this content.

Hi JR,

Seems like a simple CountIf() function would do what you ask for. See the attached.

I'm glad you got something that worked.