I would like to find values in an array that are at least an interval length apart. Lets say I have the following data set

Closed 9 hours ago.

I have a Database sheet with a list of products and each product’s details including but not limited to the product size, cost, department and more. On a separate sheet named PriceTiers, I have a list of price levels and each price level’s requirement/settings such as minimum product size, maximum product size, minimum cost, maximum cost, department and more. My objective is to have an arrayformula on my Database sheet that uses the product details to look up the correct price level on the PriceTiers sheet similar to a vlookup with multiple criteria.

I want to create a formula that returns the sum of any cells where the sum of their row value = 20. For example, B2+B22, B12+C12, B13+E15+G4, and so on. I also do not want it to call any cell twice in the same sum (for example, B12+B17+B17)

i’ve got a quite complex situation to solve with google sheets. I already solved it in a very unelegant way, and I would need your help to understand why other solutions I tried failed, and maybe to find a better solution. I will put a link to the sheet in the end of the post.

How can I force a google sheets function like AND to perform its operation individually across each scalar index when it receives two vector inputs?

Example: