J

#### Jennifer

multiple ranges. As an example, I want to count the number of rows where

both Column A and Column B have a date between 01-01-05 and 12-31-05. Where:

Column A Column B

01-02-05 12-20-05

01-06-05 02-20-06

05-06-09 03-07-05

01-02-06 01-09-06

So, in this instance, I want it to count only row 1 because both columns

match the criteria.

I've tried a couple of different Countif statements, but I can never get it

to count using the multiple criteria and ranges. Please assist.

Things I've tried:

=Countif(and(A:A,B:B), ">"&C1))+countif(and(A:A,B:B), "<"&D1) - - where C1

is equal to 01-01-05 and D1 is 12-31-05