|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 1st, 2010, 06:30 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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! 
|
|
#2
June 1st, 2010, 06:54 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
