Formula

[Guest]

I have a column of model numbers in which I need to have a cell with the
totals of all the different models being built within a certain date range.
Date model# model # 11 12 13
01-may 12 totals 2 3 2
(btwn 01may-09may)
02-may 11
03-may 11
04-may 13

07-may 12
08-may 12
09-may 13

 

[Guest]

Assuming Date/Model # are in columns A &B of Sheet1 and the output is in
Sheet2 with model #s starting in B1, then in B2:

=SUMPRODUCT(--(Sheet1!$A$2:$A$100>=DATE(2007,5,1)),--(Sheet1!$A$2:$A$100<=DATE(2007,5,9)),--(Sheet1!$B$2:$B$100=B1))

Copy across for all models

You can put your selection dates in two cells (say X1 & X2) and compare
against the cells:

=SUMPRODUCT(--(Sheet1!$A$2:$A$100>=X1),--(Sheet1!$A$2:$A$100<=X2),--(Sheet1!$B$2:$B$100=B1))
HTH

 

[Guest]

Thank you

Assuming Date/Model # are in columns A &B of Sheet1 and the output is in
Sheet2 with model #s starting in B1, then in B2:

=SUMPRODUCT(--(Sheet1!$A$2:$A$100>=DATE(2007,5,1)),--(Sheet1!$A$2:$A$100<=DATE(2007,5,9)),--(Sheet1!$B$2:$B$100=B1))

Copy across for all models

You can put your selection dates in two cells (say X1 & X2) and compare
against the cells:

=SUMPRODUCT(--(Sheet1!$A$2:$A$100>=X1),--(Sheet1!$A$2:$A$100<=X2),--(Sheet1!$B$2:$B$100=B1))
HTH