=SUMPRODUCT(--(F5:F98--"2005-09-30"),--(F5:F98<--"2006-01-01"))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sam" wrote in message
...
Search turned up nada on this:

How do I write a countif statement that says to include the line in the
count if the date on that line is between 10/01/05 and 12/31/05?

I've even tried a couple:

=IF(AND(F5:F989/30/2005,F5:F98<1/1/2006),COUNTA(F5:F98),"")
=IF(AND(F5:F989/30/2005,F5:F98<1/1/2006),COUNT(F5:F98),"")

Do I have bad syntax, bad logic, bad formula use? Do dates have to be
written out differently?


Thanks to anyone who takes the time to respond.

Sam