I'm trying to count the number of occurances by department that fall within a
specific date range(in this case monthly....ie 08/01/07 - 08/31/07)

The formula I'm using is as follows:

=COUNTIF('Filled Reqs'!$R$2:$R$389,"08/01/07")- COUNTIF('Filled
Reqs'!$R$2:$R$389,"<'09/01/07")

** this gives me the count within a given month

=COUNTIF('Filled Reqs'!$R$2:$R$389,"08/01/07")-COUNTIF('Filled
Reqs'!$R$2:$R$389,"<'09/01/07")*AND('Filled
Reqs'!$B$2:$B$389,"legal")*AND('Filled Reqs'!$o$2:$o$389,"analyst")

*** this doesn't work.... count within given month by department[/b]