Hi,
I have this formulae:
=IF(LEFT($D10,4)="Ext-",SUM(IF(Need!$F$8:Need!$F$21<"",IF(Need!$G$8:Nee d!$G$21=RIGHT($D10,LEN($D10)-SEARCH("
",$D10)),IF(Need!$E$8:Need!$E$21<$B$4,IF(Need!$E$ 8:Need!$E$21<$B$3,IF(Need!$E$8:Need!$E$21<$B$2,I F(Need!$E$8:Need!$E$21<$B$1,Need!T$8:Need!T$21,0) ,0),0),0)))),SUM(IF(Need!$F$8:Need!$F$21="",IF(Nee d!$G$8:Need!$G$21=$D10,IF(Need!$E$8:Need!$E$21<$B $4,IF(Need!$E$8:Need!$E$21<$B$3,IF(Need!$E$8:Need !$E$21<$B$2,IF(Need!$E$8:Need!$E$21<$B$1,Need!T$ 8:Need!T$21,0),0),0),0)))))

I am not able to activate that formula in array {} format. I should be able
to so that I get the right results. It is part of a macro and macro does not
accept that as an array. I have tried to record that, no acceptance. Problem
seems to be in this part:
IF(Need!$G$8:Need!$G$21=RIGHT($D10,LEN($D10)-SEARCH(" ",$D10)

When activating cell content and with shift+ctrl+enter it will be an array
and will give right results.

How could I resolve this problem?
Thanks in advance
MakeLei