Calculating a sum with incomplete cell values

I am trying to build a worksheet for Profit and loss on stocks. The data contains sold stocks, and stocks still open. On the stocks that are still open I have the ifs function in place so the p/l won...