Counting lines that meet TWO criteria
 

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

Counting lines that meet TWO criteria
 

=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

Counting lines that meet TWO criteria
 

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