COUNTIF/COUNTIFS/IF Formula

[quibilty]

You'll need to open the attached spreadsheet to understand this question. Use the "ari" tab.

I would like to create a formula in one (or multiple) column(s) that computes the following scenario:

IF a team lost the first game of a series (an "L" in column "E" next to a "1" in column "D") then what is the profit of that team winning EITHER game 2 or game 3. So, if after a game 1 loss the team wins game 2 then the number I'm looking for is the value of column "L" in the row containing the column with a "2" in column "D" and a "W" in column "E". If the team loses game 2 then I'd like to multiply the value of column "L" (in the row in which there is a "3" in column "D") by 2 and then add that value to the column "L" ("2" column "D") value.

EXAMPLE 1:

Rows 2-4....

First game an "L", the qualifier for the formula is met. The second game was an "L" so the value of L:3 (-100) is added to the value of L:4 x 2 (-100 x 2), thus giving the answer (-300).

EXAMPLE 2:

Rows 21-23....

First game an "L", the qualifier for the formula is met. The second game was an "L" so the value of L:22 (-100) is added to the value of L:23 (110 x 2), thus giving the answer of (110).

EXAMPLE 3:

Rows 37-39....

First game an "L", the qualifier for the formula is met. The second game a "W" so the answer is the value of L:38 (100). L:39 x 2 IS NOT ADDED to the value of L:38 because if a "W" is reached in game 2, then the value of L:39 is not included.

Thank you.