Excel: Find a subset of numbers that add to a given total?
Fresh3 days ago
Mar 15, 2026202757 viewsConfidence Score0%
0%
Problem
I have a column of numbers (lets say it's A1:A100) and I need to find a subset of them that sum to a certain total.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel: Find a subset of numbers that add to a given total?
Low Risk
It's possible with the Solver add-in*. The following steps worked for me in Excel 2007 and 2010. Designate a cell to hold the result (C1 for this example) - this is the target cell, and a column that excel can use for scratch-work (B1:B100 for this …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix