"?B?ZG9ubmVyczY=?=" wrote in
:

i.e. a standard spreadsheet has a list of different names (random) and
I want to do a 'word count' as such e.g. how many times 'Donnelly'
appears in the spreadsheet.


If you want to find the search text also as part of text in a cell, put
this in a cell outside the range:

=COUNTIF(A2:Z35000;"*"&"text"&"*")

Otherwise leave the widcards out:

=COUNTIF(A2:Z35000;"text")


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)