Very Slow Calculating

[Tufail]

My formula calculating is very slow, formula is as under & my active cell is
E5 !
E5 12345
J5 =IF($E5="","",IF(ISNA(VLOOKUP($E5,sl,11,)),"",VLOOKUP($E5,sl,11,)))
L5 6,200 (this cell has unit price)
M5 115.00 (this cell has exchange rate)
N5 =$L5*IF($M5=0,1,$M5)
O5 =SUMPRODUCT(($E$5:$E5=$E5)*($L$5:$L5<0)*($L$5:$L5))
Even C5 doesn't have any formula just I am putting date but still taking
long time than normal.
Any idea to make it faster ?
Thanks in advance

 

[Dave Peterson]

You showed the formulas/data in row 5.

How far down do these formulas/data go? The greater the number of rows, the
longer =sumproduct() will take to calc.

If sl has a lot of rows, then the =vlookup()'s will take a long time, too.

 

[Tufail]

all ranges are 5 ~ 4000 and i am using MO 2007.

You showed the formulas/data in row 5.

How far down do these formulas/data go? The greater the number of rows, the
longer =sumproduct() will take to calc.

If sl has a lot of rows, then the =vlookup()'s will take a long time, too.

 

[Dave Peterson]

4000 =sumproduct() formulas sound like a lot to me. Especially since each uses
more rows than the last.

Maybe you could use helper columns and alternative formulas--or live with the
delay???

 

[Tufail]

Ok i will try to reduce range, anyway thank you very much for your attention.