Date Related Query

  • Thread starter Thread starter sandy
  • Start date Start date
S

sandy

hi need help again....
I have this Data
Date Submitted On-Time
3/14/2010 x
5/29/2010 x
3/12/2010

I have to count the number of on time delivery(with x) of tasks for a
certain range example
from 3/8/2010 to 3/14/2010...for this case the return value should be 1..I
hope this is clear enough...
Thank you!
 
Assume that your DATE SUBMITTED is in A column and the ON-TIME is in B Column.

=SUMPRODUCT((A2:A100>=DATE(2010,3,8))*(A2:A100<=DATE(2010,3,14))*(B2:B100="X"))

Remember to Click Yes, if this post helps!
 
Back
Top