Racking my brain on sumif
Do this:
Highlight the sheet, Go to DATA, Sort by date. Than go to DATA, SUBTOTAL by
date.
--
Naftoli
"Bob Phillips" wrote:
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!
.
|