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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
Try the Countif function
if the ones of interest are in Column A and the recommendations are in
columns C-F
Will give you the number of times the initials in Column A is recommended.
=countif(C:F,A1)
copy down as far as you need.
"CRM" wrote:
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks