Cross referencing

I am sorry to bother you guys again – third time this week (been a nightmare alleviated by your kind help!). I have a list of products that have individual item numbers that share some common sizes and some common materials and are ordered in different quantities. When it comes to re-ordering the raw material to remake these items, I need to know how many of each item in the same type of material and size, need to be made. The attached spreadsheet shows more clearly what I am probably failing to explain! I have tried various combinations of VLOOKUP combined with MATCH but I can’t get anything to work – I guess I’m getting a little punch drunk here having spent the whole morning trying to find a solution!

in I3 dragged accross and down
=SUMPRODUCT(--($B$2:$B$27=$H3),--($F$2:$F$27=I$2),$E$2:$E$27)
then custom format cells
##,#00;-0;;@ to hide 0's

If as implied in your profile you're using XL2007 you should look to use SUMIFS in preference to SUMPRODUCT, ie:

Please Login or Register  to view this content.

in this instance you could also consider using a Pivot Table with Material as Column Label, Size as Row Label and Qty as Data Field (set to Sum)