Hi,

You may try the following array formula (Ctrl+Shift+Enter). The data is in
range A2:B4

12/12/1991 12
15/01/1992 13
21/01/1992 12

=SUM(IF((A2:A4>=A2)*(A2:A4<=A4),B2:B4))

"Laura" wrote:

> I am using DCOUNTA to count "records" (rows) in an Excel spreadsheet using
> three criteria:
> Type ="=Order"
> Date >=12/1/2005
> Date <=12/19/2005
>
> This works fine; however, I want to be able to use a reference to a cell
> containing the date, rather than having to enter the date in the DCOUNT
> criteria cells. Something like:
> Type ="=Order"
> Date >=$B$1
> Date <=$C$1
> where B1 contains the start date and C1 contains the end date.
>
> It works if I use Date =$B$1, but it won't do greater than or equal to $B$1.
>
> Suggestions using DCOUNT or any other method would be greatly appreciated.