How do you calculate figures held in multiple cells?

I've got a, hopefully, easy to solve problem.

The attachments shows you what I want to do, but I'm at a loss how to achieve the result.

The aim is to record the arbitrage outcomes of various sports matches.

For each match there are three possible outcomes: 1 = a home win, x = a draw, and 2 = an away win.

Each has it's own individual odds, stakes, and profit/loss.

What I'd like to do is calculate the values for the 'P/L ｣' column using the data held in the Win/Lose, Odds, and Stake cells. Then to calculate the overall P/L from the P/L ｣ cell (I've filled those in manually on the example).

I know how to do the formula - =IF(F6="W",H6*(G6-1),0-H6) and so on - but what I'm stuck on is how to apply that to each line in the multiple cells.

I set the multiple cells up by doing Alt+Enter. Perhaps this is where the problem lies and there's possibly a simple solution to grouping these outcomes together.

Many thanks,

Steve.