Counting multiple data in cell more than once
I have a data in a column that may be listed more than once. If the data is different in that cell the countif statement will pick it up. If the data is the same the countif statement is only picking it up once. For example if video is in the cell twice it is only picking it up once. Is there a formula will it will count all data regardless if it is in the cell twice or not. I have attached a sample. The first worksheet is where my formula is. The second worksheet has the data.
|