Sumif as a fuction of If using multiple criteria

[AMB]

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,

 

[Bob Buckland ?:-\)]

Hi Adam,

You may want to use the link below to also post this in the MS Excel discussion group and include there the version of Excel you're
working with.

=========
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 >>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[AMB]

Thanks Bob! I didn't realize I submitted to a general office discussion. I
have now submitted in the MS Excel Discussion Group.

Have a great day...

Adam