Sumproduct formula

[Amy]

Can someone help with this formula?

I am trying to find out late shipments in a particular
time frame (DATE/YEAR)

The values for $Q$2 is 01/01/04 3:00 AM and the value for
$R$2 is 04/31/04 11:00 PM

=SUMPRODUCT(((('Shipped Items'!$W$2:$W$60000>=Formulas!
$Q$2)*('Shipped Items'!$W$2:$W$60000<=Formulas!$R$2)*(DAY
('Shipped Items'!$P$2:$P$60000)&YEAR('Shipped Items'!
$P$260000>'Shipped Items'!$W$2:$W$60000)&YEAR('Shipped
Items'!$W$2:$W$60000)))))


Thanks

 

[Daniel.M]

Hi Amy,

=SUMPRODUCT(
('Shipped Items'!$W$2:$W$60000>=Formulas!$Q$2)*
('Shipped Items'!$W$2:$W$60000<=Formulas!$R$2)
)

It should be enough to count those.

Regards,

Daniel M.