I have two google sheets. One is more of a summary and the other one tracks all of the data. I need to get the price from the row on the 2nd page that is marked as entry, with a corresponding trade id to the first page, and then, if it was a long trade(Determined by the Long/Short(L/S) column on page 1, subtract the entry price from each exit price and then add those values together. If short trade it would be each entry price minus the exit entry price. Most trades will have 1 entry and 2 exits.

Basic example: Buy 3 contracts long at $10. Exit at $15 for 2 contracts and $20 for 1 contract. So it will be (exit1 - entry) (exit1 - entry) (exit2 - entry). This will give me the total points for each section of the trade. That data then needs to get displayed on the overview tab

Example google sheet: