Excel: Which numbers in a column equal a certain number (withou.

P

Pax

Which function tells me which numbers in a column equal a certain number?
For example:

25,000
100,000
2,000
19,000

Which of these numbers, added together, will give me the result of $121,000?
 
M

Myrna Larson

Go to Google newsgroup search and search for

combination equal number

in groups microsoft.public.excel.*

You'll find lots of hits on how to do this with Solver.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and delete rows on two different sheets from reference numbers 4
Counting number of cells until a criteria is met 0
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Calculate the median value before a specified list 0
Searching for low and high number 13
How to list in a column with certain number 1
Excel - count if a number falls within an array in a column & add 2
lookup and return column number 2

Top