Hi!
I have a question that to put into simple terms as a smaller example is:
1. Column A1:A10 has 10 numbers in it
2. Column B1:B10 has 10 numbers in it
3. Cell C1 requires a formula to find the sum of the largest 4 numbers in column B under the condition that the sum of the horizontally adjacent numbers in column A for each of those 4 largest numbers is less than say 18.

So, if column A had 1,2,3,4,5,6,7,8,9,10 and column B had 10,20,30,40,50,60,70,80,90,100 then the function would take the sum of (30+40+50+60 = 180) because they are the largest 4 numbers that 3+4+5+6 which = 18 are adjacent to. Of course their could exist cases where there is more than one answer (even in this problem?) so either I just need one or if possible all of them. Would be nice to know which actual cells or at least their values that are being used. I've tried using =SUM(LARGE(B1:B10,{1,2,3,4}) and putting in various < conditions but can't get it right. Thanks for the help.