Racking my brain on sumif
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!
|