Identifying Excel Entries that Add Up to a Specific Value or close to it.

[happydz]

I have a set of random amounts in a spreadsheet and I need to determine which ones add up to a 430,20 or close to it?

 

[Fazza]

this is a common enough question. googling for this thread's title found MrExcel threads like the following. There are many others outside MrExcel

Solver: Can it do this? Find the numbers that add closest to the target number. If so, how?

Howdy everyone! I know that solver can be used to find a target sum number from a set of numbers. If solver fails to find a solution--that means there's no exact match to equal the sum. Can solver be programmed to find the combination of number to get close to the target number? Thanks!

www.mrexcel.com

Looking for a specific sum within a range of numbers...

Is there a way to find out if certain cells within a range sum up to a specific number? I often find myself looking for a certain amount - like I've got an error for a specific dollar amount - but I have a range of entries, and any combination of those numbers could sum up to the total of the...

www.mrexcel.com

find a combination of numbers that equal a given sum

Hi, If I have A1 = 1, A2 = 3, A3 = 5, A4 = 7, and A5 = 9 in column A, Would someone know how to get the combination of numbers in column A that equal 13, or 24 for example? Thanks for the help

www.mrexcel.com

Closest Sum to a Given Number

Hello, I am trying to create some type of formula or VBA script that will look at a series of given numbers and identify which numbers if summed together are closest to another given number. For example if I am given the series of numbers shown below, which numbers if summed together are...

www.mrexcel.com