Array Calculations / muti-conditions

[sabascal]

Hi all,
Here is a formulas problem:

I am a big fan of array calculations as formula. This enables me to apply multiple criteria to certain operations.
=SUM(Array*IF(Array1=Cond1;1;0)*IF(Array2=Cond2;1;0)....)

My problem - this gives me complexes formulas that makes difficult controls.

How could I possibly store my condition in cells (cond 1 in A1, cond 2 in cell A2...); knowing that IF(Array1=Cond1;1;0) is an array.

Would indirect () help?

Any idea?
Thanks

 

[GlennUK]

Please give examples of what cond1 and cond2 could be.


Thanks, Glenn.

 

[sabascal]

={-SUM(Tenants!$W$4:$W$11221*IF(Tenants!$I$4:$I$11221=1;1;0)*IF(Tenants!$K$4:$K$11221=1;1;0)*IF(Tenants!$DK$4:$DK$11221>F$14;1;1))}

Cond1= I only take into account lignes that are flagged with a 1 in column I
Cond 2= I only take into account lignes for which the value in colum DK > F$14

Thanks