"Biff" wrote in news:OX$DXA5oFHA.2472
@tk2msftngp13.phx.gbl:

Hi!

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

Less "cryptic":

=COUNTIF(A2:Z35000,"*text*")


Right!

But with my example you can replace "text" with e.g B1 to search for the
text entered in B1. ;-)))


--

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