How to Scan a Sequence of Integers in Different Columns Consecutively and Accurately

Hi there everyone,

I am trying to create an equation that monitors and updates the balance of an investment account. My problem is as follows:

All I need the equation to do is add the cell containing the profit or loss of each trade taken to the cell containing the current account balance.

However, I want this done in the order the trades are being taken, which is where things get a little awry.

We are trading two different financial entities, and have two different "sections" on the same sheet displaying the profits/losses incurred for each trade for each entity. (I will add pictures below). Thus, since we would like to maintain an accurate depiction of our running account balance, we need each trade to be counted sequentially, or by the order in which they were taken. Then, once the equation detects the following number in the sequence of trades, it will select the cell containing the profit/loss incurred pertaining to that trade and add it to the cell horizontal to it containing the account balance. It will then move on to the next number in the order of trades, and add the profit/loss cell to the account balance, and so on and so forth. Normally I would be able to do this but the difficulty is that the sequence of trades are in two different columns, and thus cannot just be counted vertically.

See picture below and specific description underneath.


Attachment 391024

Cell Y2, our Current Account Balance, is where I would like the equation.

I need to count both "Trade Sequence" Columns, beginning at Column C and Column O in numerical order, starting with number 1 in C3, then number 2 in C4, number 3 in C5, number 4 in O3, number 5 in O4, and so on. (In the photo I have only gone to 20 but there are over 400 as of right now).

When the function identifies that it is the first trade in the sequence, it will select the cell containing the resulting profit/loss for that trade, and add it to the proportionate "Current Account Balance" cell. For example, when it begins, it should see that C3 contains the first number, 1, and will thus add K3 to Y3. Then, it will see number 2 in C4, and add K4 to Y4. Then it will see number 3 in C5 and add K5 to Y5. The next number is where it gets complicated.

It will see that number 4 in the sequence is in O3, and then add W3 to Y6.

What this means is that the sequence is not necessarily in vertical order, but the account balance is due to the fact that we would like to be able to see the new account balance after each trade that has been taken. Do not mind the numbers in the columns in the pictures; a few are blank because the trades resulted in neither a profit nor a loss;the concept is what is important.

Is this possible?????

Thank you guys so much for any info/help you can provide!!

Thanks! I'll post it again with an actual spreadsheet attached.