Hey,
I am looking at a list of about 4000 telephone numbers and need to search for multiple numbers and count the number of ocasions they are listed.
I tried =countif(I2:I4550,"number1, number2, number3......)
but this clearly isnt right, can anyone help me on this??
Oh and each numner is prefixed with ' . eg '0778892 so that the 0 shows.
Thanks for any help
James
Last edited by themax16; 04-23-2008 at 04:26 AM.
Hi,
you can do it with this array formula:
=SUM(--(A2:A10=TRANSPOSE(E2:E4)))
where A2:A10 is the range where the numbers are and E2:E4 is the range where the numbers you are looking for are. Because this is an array formula, you have to enter it by pressing ctrl+shift+enter instead of plain enter. After entering it as an array formula the will be { and } around the formula.
If you want to "hard code" the numbers to find, use this array formula:
=SUM(--(A2:A10={"0778892";"0778893";"0778899"}))
I am not sure if the ; symbol is the correct one, because i'm using a different locale.
Hope this helps.
- Asser
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks