take a look at this spread sheet. is this what you wanted? I assume that you are back testing a strategy? Note: on the sheet you posted the position column had little green corner tabs, excel recognized them as text not a number value. I changed them but going forward you will need to make sure they a not entered as numerical text.
I was bored... I made the assumption that Neutral was no trade since in your example the result didn't change.