Racking my brain on sumif

  • Thread starter Thread starter Victor R.
  • Start date Start date
V

Victor R.

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!
 
Try

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

etc.
 
Do this:
Highlight the sheet, Go to DATA, Sort by date. Than go to DATA, SUBTOTAL by
date.
 
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!
Click to expand...

Hello Victor,

There might be four different promising approaches to solve your
problem.
Three I have listed and compared (for another - but maybe similar -
problem) here:
http://sulprobil.com/html/sumproduct.html
Please open and examine the Excel sample file at the bottom of this
page.

The forth possible approach might be a chart.

How does your output need to look like, please?

Regards,
Bernd
 
Back
Top