Question

How to find combination of addition of number?

Answer 1

For example, I have the list of numbers, and now, I want to know which combination of numbers in the list sum up to a particular no.

First, you need to create some range names, and then apply an array formula to find the cells that sum to target value. For that, you'll have to give the values first.