Find cells combination that equal a given sum with User Defined Function.Find cells combination that equal a given sum with Solver Add-in.Find cells combination that equal a given sum with formulas.
This article, I will talk about some methods to find which cells sum up to a specific value in Excel. How to find all combinations that equal a given sum in Excel?įor example, I have the following list of numbers, and now, I want to know which combination of numbers in the list sum up to 480, in the following screenshot shown, you can see there are five groups of possible combinations that add up equal to 480, such as 300+60+120, 300+60+40+80, etc.
