Home |
Search |
Today's Posts |
#1
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
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vookup related query | Excel Worksheet Functions | |||
Date related Problem | Excel Worksheet Functions | |||
Require help related to Excel Query outer join problem | Excel Discussion (Misc queries) | |||
date related question??? | Excel Worksheet Functions | |||
Date related IF statement | Excel Worksheet Functions |