Prev: Undeletable mark--amazing properties
Next: Split report for email
From: sandy on 1 Jun 2010 01:30
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!
From: Ms-Exl-Learner on 1 Jun 2010 01:54
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!

--------------------
(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!
 | 
Pages: 1
Prev: Undeletable mark--amazing properties
Next: Split report for email