Count Frequentness

  • Thread starter Thread starter RoadKing
  • Start date Start date
R

RoadKing

Good evening:
Is it possible to count how many times a string of numbers appears in a
column? I am working on a project that has approximately 1000 telephone
numbers. I need a count on how many times a particular number appears in a
column.
Thank you in advance
John
 
Is it really a "number" or is it a telephone number complete with hyphens?
=COUNTIF(A1:A1000,2345) if number
=COUNTIF(A1:A100, "555-1212") if text
In either case the last argument can reference a cell: COUNTIF(A1:A1000,B1)
best wishes
 
Hi John

If you have a mix of numbers and text, you'd be best off using
Sumproduct:

=SUMPRODUCT(ISNUMBER(FIND("0123",A1:A10))+0)

although note that this won't count multiple occurrences of the number
string in a single cell (ie that will only count as 1 find) - which
may or may not be what you require.

Hope this helps!

Richard
 
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

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
SUMIFS ONLY UNTIL the number REPEATS 1
Count in a range of numbers 8
Excel VBA - counting cells by colors and names to it in two different rows. 0
count formula 3
counting formula 3
Counting dates but only for a certain year 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1

Back
Top