Help?

  • Thread starter Thread starter C0de-Red
  • Start date Start date
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
 
Hi C0de-Red!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
 
then this would work
=SUMPRODUCT((RIGHT(C9:C12,4)="2345")*1)
--
Don Guillett
SalesAid Software
(e-mail address removed)
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...
 
Back
Top