=SUMPRODUCT(--(I6:I250=DATE(2009,1,1)),--(I6:I250<=DATE(2009,6,30)),J6:J250)


"Anna Wood" wrote:

=SUMPRODUCT(--(I6:I250<DATE(2009,1,1)),--(ISNUMBER(I6:I250)),J6:J250)

I am using this formula to calcuate the number of square footage with an
expiration date less than 1/1/09 (some of the cells contain the value
"month-to-month").

I now need to write this same formula for expiration dates between 1/1/09
and 6/30/09.

How do I get multiple date parameters - I keep getting errors trying to use
the AND function.