offset

Hi, I believe this formula refers to column F, directly to its left. I want it to refer column E. How can I do this? Thanks!!

Please Login or Register  to view this content.

Try

=IFERROR(100-100/(1+(SUMIF(OFFSET(G64,(-1*$C$3)+1,-2,$C$3,1),">=0")/$C$3)/ABS((SUMIF(OFFSET(G64,(-1*$C$3)+1,-2,$C$3,1),"<0")/$C$3))),0)

Hi thanks, that works!