Maybe the heavy hitters know; no steroids please. . .
Use sumif to add fields based upon year

On sheet1 col A have numerous part numbers for items. Many of these
items repeat.
Also on sheet1 col E have open shipment quantities for that row, and
in Col F have the expected shipdate "yyyy-ww"

Need to do a sumif from another worksheet to total the expected
shipment quantities of that item for the year 2008.

Ideas?

IOW:

SOURCE DATA
ITEM ON ORDER YEAR-WEEK
ABC 10 2008-10
ABC 20 2009-10
IEI 5 2008-06
EOE 1 2009-01
IEI 66 2009-25

RESULT PAGE

ITEM: 2008 SHIPMNTS

ABC 10
EOE 0
IEI 5


TIA for all your thoughts.

Pierre