sum if multiple conditions are met, where order of numbers in array matters

Hi! I am trying to come up with an excel formula for the following situation:

I have a table with 1000 rows down and 10 columns across. In the array for each row there could be a number in 1 to 10 of the columns. For each row, if there is a number in column K there must also be a number in columns B,C,D,E,F,G,H,I and J. Similarly if there is a number in column E there must also be a number in B,C and D.

I need to make a formula that does the following:

First, it looks to see if any number in B:K of each row is above X. If a number is above X then I need to find out if there is a second number in the row above Y. If there is a number above Y then I need to return the min of that number minus X and another number Z.

Please let me know if you can help!

THANK YOU!
KC

It will be great if you provide a sample data sheet for your problem. Thanks.

Regards,
Vikan

Hi! Thank you both for your help. I attached a sample spreadsheet with some detail.

Thank you again for your help! I'm sorry my example doesn't make much sense and the formula i tried to make in column q is incorrect.

If we use row 7 as an example, in column Q i'd like a to find the first number in row 7 that is larger than x, 500 --- in this case it is 3000. In row R I would like to find the first number in row that is larger then Y, starting to the right of the cell that contained the result of the first formula, so starting at C7 instead of B7. So in this case the result would be 800.

Thank you!