i would like to use a count function(possibly =countif()) to count through out a column. in that column i have cells with multiple entries.
So for example, cell a1 could contain "Paul", "John" and "Andy". Cell a2 could contain "Paul", "John" and "peter". Cell a2 could contain "Paul", "Nigel" and "peter".
i want to be able to count the number of "Paul's" that occur through out column A. The count formula should return the value: 3 as there are 3 "Pauls" entered in column A.
Please bear in mind that there are multiple entries in each cell that have been separated by ALT+ENTER. I have tried in vain to successfully carry out any formulae containing ALT+ENTER.
Can you help?