Hello,

I am trying to create a formula to sum total units sold as a function of a
list of zip codes and product codes. I have 30,000 lines of sales data where
the 1st column is Zip Code, 2nd column is Item Code, 3rd is Units Sold. I
need to sum the Units Sold for a list of national zip codes only if they
match a list of 520 Product Codes.

The formula I have tried which does NOT work is as follows:

=IF(A2='Sales Data'!$A$2:$A$30000,SUMIF('Sales Data'!$B$2:$B$30000,'Item
Codes'!$A$2:$A$520,'Sales Data'!$C$2:$C$30000),FALSE)

Please let me know what other information you need to assist me. I
appreciate the help anyone out there can provide.

Regards,
--
Adam B
National Business Analyst