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

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.

"Sachin Narute" wrote:

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

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

--
Regards,
Tom Ogilvy


"Sachin Narute" wrote in message
...
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

=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" wrote in message
...
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

Thank You Sir,

Regards,

SACHIN

"William Horton" wrote:

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.

"Sachin Narute" wrote:

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