sumif formula

[Cam]

I'm trying to get this formula to work, The first 2 conditions seem to be applied but the rest do not.

Is it not valid to use an OR condition in a CSE formula.

{SUM(IF($D$2:$D$2000=$C22,IF($E$2:$E$2000="ABC","",IF(OR($K$2:$K$2000>0.01,$A$2:$A$2000<$D$2:$D$2000),($G$2:$G$2000)))))}

 

[Aladin Akyurek]

Not sure but try:

=SUMPRODUCT(($D$2:$D$2000=$C22)*($E$2:$E$2000="ABC")*(($K$2:$K$2000>0.01)+($A$2:$A$2000<$D$2:$D$2000)),$G$2:$G$2000)

which is NOT array-entered.

 

[IML]

On 2002-08-27 14:49, Cam wrote:
I'm trying to get this formula to work, The first 2 conditions seem to be applied but the rest do not.

Is it not valid to use an OR condition in a CSE formula.

{SUM(IF($D$2:$D$2000=$C22,IF($E$2:$E$2000="ABC","",IF(OR($K$2:$K$2000>0.01,$A$2:$A$2000<$D$2:$D$2000),($G$2:$G$2000)))))}

Try replacing ors with + and ands with *.
for example
=or(a1=1,b1=2)
becomes ((a1=1)+(b1=2))
=and(a1=1,b1=2)
becomes ((a1=1)*(b1=2))