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?

Ive 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

=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

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html
You might need to use syntax such as
=sumproduct(--(F5:F98DATE(2005,9,30)), --(F5:F98<DATE(2006,1,1))
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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