J JuliaC Oct 27, 2004 #1 Hello. I need to create a formula that will find the amounts on spreadsheet that add up to a particular total. Can someone help
Hello. I need to create a formula that will find the amounts on spreadsheet that add up to a particular total. Can someone help
J Jim Oct 27, 2004 #2 Sure , give the sample data or try DATA> SUBTOTALS from the excel menu. Lemme know if any help required!
Sure , give the sample data or try DATA> SUBTOTALS from the excel menu. Lemme know if any help required!
F Frank Kabel Oct 27, 2004 #3 Hi - how many values do you have - do you only need one valid answer or all possible answers - do you have negative values
Hi - how many values do you have - do you only need one valid answer or all possible answers - do you have negative values
P Paul Corrado Oct 27, 2004 #4 You can use Excel's Solver to arrive at A solution With the data for example in A1:A10 and the formula =SUMPRODUCT(A1:A10,B1:B10) in cell C1 Select Solver from the Tools menu In the window that opens up enter the following "Set Target Cell" C1 (your sumproduct formula) "Equal To:" select "Value of: and enter the figure you are seeking "By Changing Cells" enter B1:B10 "Subject to the Constraints" select Add and enter "Cell Reference" B1:B10" Click the drop down in the center and select "bin" Click Add Then Click Solve HTH PC
You can use Excel's Solver to arrive at A solution With the data for example in A1:A10 and the formula =SUMPRODUCT(A1:A10,B1:B10) in cell C1 Select Solver from the Tools menu In the window that opens up enter the following "Set Target Cell" C1 (your sumproduct formula) "Equal To:" select "Value of: and enter the figure you are seeking "By Changing Cells" enter B1:B10 "Subject to the Constraints" select Add and enter "Cell Reference" B1:B10" Click the drop down in the center and select "bin" Click Add Then Click Solve HTH PC
