Match between two lists

Hi,

I've got column A with 200 rows of zipcodes of all my clients, and column B with 15 rows of zipcodes within in a sales district.

How do I use excel to find out how many of my clients in column A are located in the sales district column B? In another words, count the instances where a zip code from column A matches with the 15 rows of zipcodes in column B.

Thank You!!

Frank

You could just use a COUNTIF formula

=COUNTIF($A$1:$A$200,$B1)

Assumes B1 to B15 is your matched zipcodes and C1 (copied down) to C15 is where this formula is.

Chance2,

Thank you for your response! Yes, your answer does allow me to arrive at my answer, however, it'll take 2 steps for me to arrive at a total because I will have to sum up all the "countif" matches when your formula is applied.

Do you know of any other way where I can apply a formula and have the total appear in 1 step?

Thank You!

Frank

Originally Posted by shg

=sum(index(countif(a1:a200, b1:b15), 0))

BEAUTIFUL!!!! thank you!!

How about a CSE formula...

=SUM(COUNTIF($A$1:$A200,$B$1:$B$15))

Enter this formula into C1 and then use Ctrl+Shift+Enter to get the brackets.

Originally Posted by Chance2

How about a CSE formula...

=SUM(COUNTIF($A$1:$A200,$B$1:$B$15))

Enter this formula into C1 and then use Ctrl+Shift+Enter to get the brackets.

This worked too!! I need to really dig into the CSE formula. I've heard of this in passing many times, and don't it well enough to know how to apply it.

Thanks!