Hi, I have the following formula, which does not work, since Array and
AND cannot be combined.

{=-SUM(IF($B27='E-front CFs'!$A$8:$A$3285;IF($G$6='E-front
CFs'!$J$8:$J$3285;IF(AND($Y$5<='E-front
CFs'!$D$8:$D$3285;$Y$6='E-front CFs'!$D$8:$D$3285);'E-front
CFs'!$H$8:$H$3285;0);0);0))}

What this formula tries to do is extracting cash flows from a file
within a certain range of time (IF(AND($Y$5<='E-front
CFs'!$D$8:$D$3285;$Y$6='E-front CFs'!$D$8:$D$3285). $Y$5 and $Y$6 are
references to two different dates, i.e. 14.06.2006 and 30.06.2006.
Unfortunately I was told that the AND-formula within an Array formula
does not work, but is there a way to get around this problem?

Thanks for helping.

Kuede