I'm not sure what function I need to use to accomplish what I'm trying to
do. I have a column that has a number of products listed:

Column A
Product 1
Product 2
Product 3
etc...

I have another tab that is a data dump from Microsoft Access. One column in
this dump includes dates and another column includes the product. I would
like to write a function that counts how many of "Product 1" were sold during
a time frame. The data dump includes everything from January 1st. But if I
only want to calculate the number of Product 1's that were sold in February
or March, how can I do this. I thought i could do =If(And("Date
Column"=03/01/05,"Date Column"<=03/31/05),countif(Product Column,"Product
1"),0)

Obviously that didn't work. Can anyone help?