You cannot use entire columns with SUMPRODUCT.

Specify your range.
=SUMPRODUCT(--(Sheet2!B1:B1000=D2),--(Sheet2!B1:B1000<C2),--(Sheet2!H1:H1000))

HTH,
Paul

--

"Sarah (OGI)" wrote in message
...
I have entered the following expression:
=SUMPRODUCT(--(Sheet2!B:B=D2),--(Sheet2!B:B<C2),--(Sheet2!H:H))

D2 shows 01/09/2005 and C2 shows 01/09/2006.

I have some data on Sheet 2 with data listed as follows:
Date/Class Code/Company Name/Amount

I would like to sum the amounts where the dates are between D2 and C2.

I'm getting a result of #NUM!

Any suggestions? I'm not sure I'm using the right function, but I'm
asking
for multiple criteria, i.e. where the date is = one date but < another
date.