Counting lines that meet TWO criteria

[Guest]

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:F98>9/30/2005,F5:F98<1/1/2006),COUNTA(F5:F98),"")
=IF(AND(F5:F98>9/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

 

[Bob Phillips]

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bernard Liengme]

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html
You might need to use syntax such as
=sumproduct(--(F5:F98>DATE(2005,9,30)), --(F5:F98<DATE(2006,1,1))