I have a list of random customer zip codes in column A. Because of the leading zero problem, they are formatted as text.
I have a list of all zip codes in Essex County in column B. It is also formatted as text. I named that range "essex".
I want to be able to answer the following question: "How many people in column A are from Essex County?"
I have tried =COUNTIF(A:A,essex) and I have tried =COUNTIF(A:A,B:B) Neither formula works. They both return 0, even though I have many Essex County zip codes in column A.
I know that I can use something like =COUNTIF(A:A,B1)+COUNTIF(A:A,B2)+COUNTIF(A:A,B3) etc. But that will get very long very quickly! Is there a simpler formula?
I appreciate your help!