Counting in between a date range with conditions

[Courtney Rae]

I am trying to count in between a date range with conditions
(condition is the department code). This is the formula I have that is
not working:

=Sumproduct((A1:A779>=Date(2009,1,1))*(A1:A779<=Date(2009,1,31))*
(B1:B779="Department"))

 

[Dave Peterson]

How do you know that it's wrong? What happens?

The formula looks ok to me. Maybe the data isn't correct. Any chance that the
values in column A aren't really dates--that they're just plain old text?

Any chance that the values in column B aren't really "department"--maybe they
have leading/trailing spaces?

 

[Courtney Rae]

How do you know that it's wrong?  What happens?

The formula looks ok to me.  Maybe the data isn't correct.  Any chance that the
values in column A aren't really dates--that they're just plain old text?

Any chance that the values in column B aren't really "department"--maybe they
have leading/trailing spaces?

Thanks! I just had to format the dates to dates!