simplyfing formua which uses offset and abs

I've attached a small example of a formula (relative strength indicator) which I found on the net.

The formula (in column B) uses an average period (cell D3) to calculate the relative strength of the changes shown in column A, normalized as a scale between 0 and 100.

But... when I added this formula to my workbook, it slows it down considerably and I'm not sure why. (the slowing down is made evident when using Solver to run through iterations which involve several formulas including this one)

It seems that the same results could be obtained using something other than indirect (and/or abs)

Any suggestions?

Thanks!

Try

=100-100/(1+(SUMIF($A4:INDEX($A4:$A$1000,$D$3),">=0")/$D$3)/ABS((SUMIF($A4:INDEX($A4:$A$1000,$D$3),"<0")/$D$3)))

Thanks! That works.

Hi, Lee, thanks for catching that. Yes, D3 is a variable in the overall scheme of my workbook, so this will help.

Sure, will let you know. I'll try to do an empirical test: see how many iterations Solver does per minute on the original formula vs yours.