I have the follwing sheet

A B C D E F G H I J K
101Â* 400Â* 18Â* 200Â* 2Â* 200Â* 8Â* 200Â* 6Â* 200Â* 10
102Â* 400Â* 12Â* 200Â* 5Â* 200Â* 7Â* 200Â* 4Â* 199Â* 8
103Â* 399Â* 17Â* 199Â* 7Â* 200Â* 7Â* 199Â* 9Â* 199Â* 10
104Â* 395Â* 13Â* 195Â* 5Â* 200Â* 6Â* 195Â* 7Â* 190Â* 5
105Â* 390Â* 15Â* 195Â* 7Â* 195Â* 2Â* 195Â* 8Â* 190Â* 3
106Â* 390Â* 12Â* 195Â* 5Â* 190Â* 2Â* 195Â* 7Â* 190Â* 5

I like to calculate the numbers in column C using a formula in stead of doing it manually.

The reuslts are calculated from this logic:

Columns C is the sum of the two highest values in columns E, G, I and K, but only if the numbers are next to one of the two highest numbers in columns D, F, H and J.

Thus the resultat for 101 is 18 because the two highest numbers in D, F, H and J are 200 and the two highest numbers in E, G, I and K are 8 and 10.

The resultat of 103 is 17 because 7 is to the right of 200 (highest number in D, F, H and J) a,d 10 is the highest number to the right of an occurance of 199.

I hope you understand the logic.