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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RoadKing" <(E-Mail Removed)> wrote in message
news:ZH0Jh.3675$(E-Mail Removed)...
> 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
>
>
>

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


On 11 Mar, 23:57, "RoadKing" <jddona...@bellsouth.net> wrote:
> 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