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


"Dave Peterson" wrote:

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 wrote:

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,)),"",VLOO KUP($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