Counting records in a column range occuring between specific dates
You need COUNTIF's big brother, SUMPRODUCT():
=SUMPRODUCT(--(A1:A100=DATEVALUE("12/1/2008")),--(A1:A100<=DATEVALUE("12/31/2008")))
--
Gary''s Student - gsnu200828
"Jeremy Prosser" wrote:
I'm using Excel 2003, Win XP. I just want to enter a funtion/formula that
counts how many times a record appears in a range between two specific dates
rather than having to filter the records and do a count. I've been trying
the COUNTIF function but without any luck. Example:
=COUNTIF(A1:A200,=12012008,<=12312008). I know this is completely wrong
but you get the idea. Thanks in advance. Jeremy.
|