countif function - need assistance badly

[Suzanne Souza]

Hi there,

I need to figure out the COUNTIF string for my problem. Here's m
table:

Column A Column B
July 12, 2004 x
July 13, 2004 x
July 16, 2004 x
July 18, 2004 x

I cannot figure out a formula that would count the number of x's i
column B if that row that has the "x" has a date between July 12, 200
and July 16, 2004.

Thanks!
Suzann

 

[Govind]

Hi,

Try this.

=COUNTIF(B5:B11,">=12.7.2004") - COUNTIF(B5:B11,">16.7.2004")

Regards

Govind.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100>=DATE(2004,7,12)),--(A1:A100<=DATE
(2004,7,16)),--(B1:B100="X"))

 

[Andy B]

Hi

Try something like:
=SUMPRODUCT((A2:A20>DATE(2004,7,11))*(A2:A20<DATE(2004,7,17))*(B2:B20="x"))