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)
https://docs.google.com/spreadsheets/d/1y8imBN_SnEXJ6UZZA4Y2v0he2f_F74lMHZPZPjZcsmw/edit?usp=sharing
enter image description here
Tried playing with LOOKUP, INDEX, IF, SUMIF functions but could not come up with anything. Not sure about array functions
New contributor
bluefirebird101 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.