Date Related Query
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<=DA TE(2010,3,14))*(B2:B100="X"))
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"sandy" wrote:
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!
|