Countif data does not equal any number in a range

I'm working on a Google Sheet where I am entering zipcode information. Column A will have zip codes received from survey respondents.

Columns B, C, D and E include reference lists of zipcodes in different areas. I need to know how many respondents live in each group of zipcodes, so I'm using this formula to tally that:

=sumproduct(countif(A2:A1000,B2:B1000)) 

I'm looking for a formula to capture any number entered in Column A that doesn't match any of my reference zip codes in columns B, C, D and E.

I've tried:

=sumproduct(countif(A2:A1000,<>B2:B1000))

and am getting a formula parse error.

Most of the examples I'm seeing are using really small datasets, so they're using a formula like =sumproduct(countif(A2:A1000,<>"DATA")), but I am working with large data ranges, so that's not particularly helpful.

Some other examples I've seen that seem similar are being recommended formulas that are more complex than what I'm familiar with, so I'm not able to pick apart what might be useful to me.

Edit: Sample data

Many thanks.

I created a sample data for you<br>
Try this formula

=IFERROR(FILTER(A2:A, ISERROR(MATCH(A2:A,TOCOL(UNIQUE(B2:E)) , FALSE))), "No Match")

Explanation:

This formula is used to filter a range of values in column A based on whether they have a match in columns B to E. Let's break down the formula step by step:

1. UNIQUE(B2:E) returns a list of unique values from columns B to E. It creates a single column of unique values by stacking the values from those columns vertically.

2. TOCOL(UNIQUE(B2:E)) converts the column of unique values into a row by transposing it. This step is necessary because the MATCH function works with row vectors, and we want to compare it with the values in column A.

3. MATCH(A2:A, TOCOL(UNIQUE(B2:E)), FALSE) compares each value in column A (A2:A) with the unique values in columns B to E. It returns the relative position of the matching value in the unique values list or an error value (#N/A) if there's no match.

4. ISERROR(MATCH(A2:A, TOCOL(UNIQUE(B2:E)), FALSE)) checks if there is an error (no match) for each value in column A. It returns an array of TRUE and FALSE values, where TRUE indicates no match and FALSE indicates a match.

5. FILTER(A2:A, ISERROR(MATCH(A2:A, TOCOL(UNIQUE(B2:E)), FALSE))) filters the values in column A based on the array of TRUE and FALSE values obtained from the previous step. It returns only the values from column A that do not have a match in columns B to E.

6. IFERROR(FILTER(A2:A, ISERROR(MATCH(A2:A, TOCOL(UNIQUE(B2:E)), FALSE))), "No Match") wraps the filtered values from step 5 with the IFERROR function. If the FILTER function returns any values, they are displayed. Otherwise, if there are no matches, it displays the text "No Match".

As required, the formula filters the values in column A and returns only those values that do not have a match in columns B to E. If there are no matches, it displays the text "No Match", You can replace "No Match" with "" to return nothing.

Used formulas help<br>
IFERROR - FILTER - ISERROR - MATCH - UNIQUE

Welcome to stackoverflow

Simple COUNTIFS() should work with FILTER() function.

=FILTER(A2:A,INDEX(COUNTIFS(B2:E,A2:A))=0)