Forum Discussion
Find the sum of a specific value within multiple values
Thank you for your reply, but it didn't work. it gives me the value of 0. from what I understood it it didn't find the value of 17 therefore it equaled 0.
what I want to know is which of the values in column A could equal 17, and how many if more than one option.
Another solution! You can use the Solver add-in in Excel to find the combination of values in the column that add up to 17.
Here are the steps to follow:
- Select the cells containing the values in the column that you want to search.
- Click on the "Data" tab in the Excel ribbon.
- Click on the "Solver" button in the "Analysis" group.
- In the Solver Parameters dialog box, set the following options:
- Set the "Set Objective" field to the cell where you want to display the sum of the selected values.
- Set the "To" field to "Value of" and enter 17.
- Set the "By Changing Variable Cells" field to the range of cells containing the values in the column that you want to search.
5. Click on the "Options" button and make sure that the "Assume Linear Model" option is unchecked.
6. Click on the "Solve" button and wait for Solver to find a combination of values that add up to 17.
7. If Solver finds a solution, click on the "OK" button to apply the solution to your worksheet.
Note that Solver may not always find a solution, especially if there are no combinations of values that add up to 17. In that case, you may need to adjust the values in the column or try a different approach. Also, Solver is an add-in that may need to be installed and enabled in Excel before you can use it.