countif(and function

[jlhart76]

Have a column of dates, and would like to count number that fall within specific range.

ex:
Dates
1/1
1/7
1/12
1/13
1/19
1/21
Total between 1/4 & 1/15 = 3

=COUNTIF(AND(C1:C6,">=1/4/09","<=1/15/09")
=COUNTIF(AND(C1:C6,">=1/4/09"),(C1:C6,"<=1/15/09")
both give message that formula contains error

[Flintstone]

Hello jlhart76:

Try this.

=SUMPRODUCT(--(C1:C6>=A1),--(C1:C6<=A2))

Cells A1 and A2 contain the dates in question.

[jlhart76]

Thanks, it seems to work.