Selecting values from a range that equal a specific total

[Guest]

If I have a list of values (all different numbers) all in a column, and I
want to select values within that column that equal a specific total, is
there a function in excel that will help me?

 

[Guest]

Very simple. See:

http://groups.google.com/group/micr...up+to+group:*excel*+author:otten&rnum=1&hl=en

 

[Guest]

Thanks, but that doesnt seem at all simple. Far and above my level of
understanding I'm affraid.

 

[Guest]

Try to Google "Solver" you may find what you are looking for

 

[Guest]

Hi Matt UK,

for me, i have to build formulas on a one or more columns to match your
need.
It can help me find the combined numbers that will be summed as "equal of
specific total"
only if my data has the corresponding combination.

You can also find links of suggestive formulas from many sites.

happy holidays..