SUM Formula expanded

A

Angie

Is there a way to have Excel tell what values in a given
column can be combined to equal a given value? For
example...there are x number of rows in column B. Search
column B to determine a combination of values that will
equal $700?
 

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

List all tables, including document structure 0
Combine text under different condition 3
Copy addition formula of non-consecutive horizontal cells 2
Help with lots of formulas 3
Trying to count based on multiple criteria & cell comparisons 4
Calculate the median value before a specified list 0
Countif or other formula needed for multiple data/critera results 3
Highlight every 5th recurrence in a column for a given value/id 1

Top