I am looking for a sumproduct formula that counts how many Titles in a sheet
are Backordered and have Availability date between D1 and D2.
The data resides in two separate sheets:

Sheet1
=====
Title1 InStock
Title 2 Backorder

Sheet2
=====
Title2 03/15/08

The formula would be something like:
=sumproduct((Sheet1!A1:A100=€�Backorder€�)*(isnu mber(match(Sheet1!A1:A100,Sheet2!A1:A50,0)))€¦
and here is where I dont know how to further check the date associated with
a given item.

Thank you.