Help?

C

C0de-Red

Ohkey here from I101 to I3000 contain phone numbers.... what i need i
A5 is for it to count how many times say "250-432-2345" isin I101 t
I3000. like how many times it exists amoung those cells
 
N

Norman Harker

Hi C0de-Red!

Try:
=COUNTIF(I101:I3000,"250-432-2345")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
C

CLR

One thing to watch out for in a situation like this, is to be sure that all
the numbers in the search range are formatted with the hyphens exactly the
same way..........250-432-2345, 250-4322345, and 2504322345 are not the same
when being searched for..........

Vaya con Dios,
Chuck, CABGx3
 
D

Don Guillett

then this would work
=SUMPRODUCT((RIGHT(C9:C12,4)="2345")*1)
--
Don Guillett
SalesAid Software
[email protected]
CLR said:
One thing to watch out for in a situation like this, is to be sure that all
the numbers in the search range are formatted with the hyphens exactly the
same way..........250-432-2345, 250-4322345, and 2504322345 are not the same
when being searched for..........

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Top