countif function - need assistance badly

  • Thread starter Thread starter Suzanne Souza
  • Start date Start date
S

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
 
Hi,

Try this.

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

Regards

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

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