I have a table whe

Col C is a text field
Col D is a text field
Col E is a date field
Col H is a numeric field

I want to find rows that match multiple criteria & sum the value in Col H.
I am using the following formula:

=SUMPRODUCT(--(Sheet1!E$1:E$9999=A10),--(Sheet1!E$1:E$9999<A11),--(Sheet1!C$1:C$9999=C$6),--(Sheet1!D$1:D$9999="A"),Sheet1!H$1:H$9999)

This is returning #VALUE. TIA

--
Tony