How do I count the number of alpha occurences in a range?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting the number of times a character occurs in a cell 1
Count function 2
Count a number in a range with cells containing more than one numb 12
SUMPRODUCT and finding text within a cell 6
Counting characters 5
Counting the number of occurrences... 2
count function 2
i think i need count function help 1

Back
Top