Addition function of multiple cells
Does anyone know if there is a function that will take a list of numbers in
different cells and run various addition combinations on the list to detemine
which cells will add to a specific number? For example:
A1 = 1
A2 = 2
A3 = 5
A4 = 7
I want to know which cells added to gether will give me 6...answer = A1 + A3
|