|
Date Related Query
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! |
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! |
| All times are GMT +1. The time now is 05:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com