SUMIF or SUMIFS =- With named range..

[tlangsr]

Sheet 1 - Summary page with County names in 10 columns
Sheet 2 - All sales for out company - 3 columns - ZipCode, Total Items sold to that zip code, Dollar Value (Columns A-C)
Sheet 3 - List of Each NH County and Zip Codes - 10 columns with each row containing the zip ode for that column (columns A-J)

Named ranges created

I identified the Counry_1, County_2 etc as a unique Named Range (Sheet 3)
I identified the Zipcode where sales occurred as All_Sales_Zip (Sheet 2)
I identified the Totals items as Zip_Item_Totals (Sheet 2)
I identified the Totals Dollars in zip as Zip_Sales_Dollars (Sheet 2)

Formulas tried:
=+SUMIFS('Zip_Item_Totals','All_Sales_Zip,"=County_1")

=+SUMIF('ALL_Sales_Zip,"=County_1", 'Zip_Item_Totals)

***Note tried these with a range too instead of

I am trying to show sales by county on a summary page based the defined list of zip codes..

I keep getting '0' as the answer to the formula.. I think because it is only looking at the single 1st zipcode.. when I manually enter a specific zipcode I get the summary...

thoughts?

 

[Aladin Akyurek]

Looks like...

=SUMPRODUCT(SUMIFS(Zip_Item_Totals, Country_1, All_Sales_Zip))

 

[Marcelo Branco]

Not sure i understand your data setup

Assuming in Summary

A1=County_1; B1=County_2; C1=County_3 and so on (values identical to the named named ranges in Sheet3)

Maybe...
A2 copied across
=SUMPRODUCT(SUMIFS(Zip_Sales_Dollars,All_Sales_Zip,INDIRECT(A1)))

Hope this helps

M.

 

[Aladin Akyurek]

Looks like...

=SUMPRODUCT(SUMIFS(Zip_Item_Totals, Country_1, All_Sales_Zip))

Edit...

=SUMPRODUCT(SUMIFS(Zip_Item_Totals, All_Sales_Zip, Country_1))