Use this general syntax:

....)*(date_range=start_date)*(date_range<=end_da te)...

--
Biff
Microsoft Excel MVP


"adimar" wrote in message
...
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")*(isnumber (match(Sheet1!A1:A100,Sheet2!A1:A50,0))).
and here is where I don't know how to further check the date associated
with
a given item.

Thank you.