Summing value on a column in multiple criterias in multiple sheet

Hi All,
I've been trying to search around for answers on this formula for days. But it's invalid. Maybe it's just me not knowing well enough. :P

E.g. Sum values in my A2E Factor (MDL (Live)'!DD9:DD10000) if the following criterias are True:
1) Department (MDL (Live)'!C9:C10000) = H
2) Drawing Type (MDL (Live)'!R$9:R10000) = Basic
3) Required (MDL (Live)'!CU9:CU10000) = 1
4) Plan Minimum (MDL (Live)'!CY9:CY10000) < (Data!K4)

Answers are to be reflected in Data!K6

Any ideas on how to do this? Maybe I'm not advance enough to understand it. Your help is greatly appreciated.
Attached is for your reference.

Thanks.