I need help, Formula in L4 is fine as below. I'm trying to get L6, so
after W
is inserted into I6 instead of adding up H4-H6 it starts adding up at
H7 down
until next W is inserted, then start process again.
I would like a formula that doesn't matter where L or W a it justs
starts
adding from the last W for column I.

=IF(ISERROR(IF(I4="W",-H4,H4*E4/G4)),"-",IF(I4="L",-H4,H4*E4/G4))


B E G H I J K L

4 2.5 6 4 2.50 L 5 7.5 -2.5

5 7.5 5 2 3.75 L 11.25 13.75 -6.25

6 13.75 6 2 5 W - - 8.75

7 2.5 7 2 1.25 L 3.75 6.25 -1.25

I hope this all makes sence.

Thanks


--
v4mpy
------------------------------------------------------------------------
v4mpy's Profile: http://www.excelforum.com/member.php...o&userid=31881
View this thread: http://www.excelforum.com/showthread...hreadid=516093