Summing value on a column in multiple criterias in multiple sheet

[radicrains]

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.

[Moo the Dog]

Try this instead:

Please Login or Register  to view this content.

- Moo

[radicrains]

I did that once. But somehow the value was different from what i wanted when i applied it to "actual minimum" rather than "plan minimum" so i just brush off that formula without realising the logic that 0 is also < Data!K4, therefore summing the value in A2E factor. Oh gosh, careless me. HAHA..

Thanks Moo.. You made me re-open the possibility of that formula again or else, i would have never consider it. hahaha!
Enjoy your day!