Remember Me?

#1
October 27th 04, 09:54 PM
 JuliaC Posts: n/a

Hello. I need to create a formula that will find the amounts on a

--
JuliaC
------------------------------------------------------------------------
JuliaC's Profile: http://www.excelforum.com/member.php...o&userid=15790

#2
October 27th 04, 10:20 PM
 Jim Posts: n/a

Sure , give the sample data or try DATA SUBTOTALS from the excel menu.

Lemme know if any help required!

--
Hope it Helps!
Jim
India

"JuliaC" wrote in message
...

Hello. I need to create a formula that will find the amounts on a

--
JuliaC
------------------------------------------------------------------------
JuliaC's Profile:

http://www.excelforum.com/member.php...o&userid=15790

#3
October 27th 04, 10:22 PM
 Frank Kabel Posts: n/a

Hi
- how many values do you have
- do you only need one valid answer or all possible answers
- do you have negative values

--
Regards
Frank Kabel
Frankfurt, Germany

"JuliaC" schrieb im Newsbeitrag
...

Hello. I need to create a formula that will find the amounts on a

--
JuliaC
---------------------------------------------------------------------

---
JuliaC's Profile:

http://www.excelforum.com/member.php...o&userid=15790

#4
October 27th 04, 11:12 PM

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"

Then Click Solve

HTH

PC

"JuliaC" wrote in message
...

Hello. I need to create a formula that will find the amounts on a

--
JuliaC
------------------------------------------------------------------------
JuliaC's Profile:

http://www.excelforum.com/member.php...o&userid=15790

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post jobby55 Excel Discussion (Misc queries) 2 January 13th 05 05:00 AM jenniss Excel Discussion (Misc queries) 5 January 6th 05 04:50 PM anon Charts and Charting in Excel 1 December 15th 04 08:55 PM dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM don Excel Discussion (Misc queries) 0 November 28th 04 09:21 PM

All times are GMT +1. The time now is 07:32 AM.