Try

=SUMPRODUCT(--(Sheet1!$A$1:$A$200=1234),--(Sheet1!$B$1:$B$200=--"2010-06-01"))

etc.

--

HTH

Bob

"Victor R." wrote in message
...
I have a report download that roughly looks like this:

Part # Date Qty
1234 6/1/10 25
1234 6/3/10 50
1234 6/7/10 100
4567 6/1/10 75
4567 6/3/10 45
4567 6/7/10 20

I am trying to sum up the quantites for each part number by date into
another worksheet.

Help!