Try this:

=COUNTIF(A1:D50,H1)

Where you enter the stock symbol of interest into H1.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"CRM" wrote in message
...
I have a list containing the 3 and 4 letter stock symbols of "buy"
recommendations from four different brokers. I want to count the number
of
times the same stock symbols occur within this list.