Plz Help Me

[Sachin Narute]

I have one problem
Date Conditions
1 10-10-2005 Pass
2 10-10-2005 Fail
3 12-10-2005 Pass
4 12-10-2005 Pass
5 13-10-2005 Fail
6 14-10-2005 Pass
7 14-10-2005 Pass
8 15-10-2005 Fail
9 17-10-2005 Pass
10 18-10-2005 Fail

I want to Count no of Pass Conditions From 10-10-2005 To 17-10-2005
(1 week). What is formula for this problem. Plz help me.

Regards,
SVN

 

[William Horton]

You can use the formula
=SUMPRODUCT(((C1:C10)="Pass")*1,((B1:B10)>=38635)*1,((B1:B10)<=38642)*1)
Where C1:C10 contains pass or fail and B1:B10 contains your dates. In the
formula "38635" is the number value that Excel represents the date 10/10/2005
as and "38642" is the number value that Excel represents the date 17/10/2005
as. You can find out these values by changing the number format to general
on any cell that contains a date.

Hope this helps.

 

[Tom Ogilvy]

=sumproduct(--(A1:A10>=DateValue("10-10-2005")),--(A1:A10<=DateValue("10-17-
2005")),--(B1:B10="Pass))

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A100>=--"2005-10-10"),--(A2:A100<=--"2005-10-17"),--(B2:B1
00="Pass"))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Sachin Narute]

Thank You Sir,

Regards,

SACHIN

You can use the formula
=SUMPRODUCT(((C1:C10)="Pass")*1,((B1:B10)>=38635)*1,((B1:B10)<=38642)*1)
Where C1:C10 contains pass or fail and B1:B10 contains your dates. In the
formula "38635" is the number value that Excel represents the date 10/10/2005
as and "38642" is the number value that Excel represents the date 17/10/2005
as. You can find out these values by changing the number format to general
on any cell that contains a date.

Hope this helps.