Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 27th 04, 09:54 PM
JuliaC
 
Posts: n/a
Default Please help create a formula


Hello. I need to create a formula that will find the amounts on a
spreadsheet that add up to a particular total. Can someone help?


--
JuliaC
------------------------------------------------------------------------
JuliaC's Profile: http://www.excelforum.com/member.php...o&userid=15790
View this thread: http://www.excelforum.com/showthread...hreadid=272980


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

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
spreadsheet that add up to a particular total. Can someone help?


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

http://www.excelforum.com/member.php...o&userid=15790
View this thread: http://www.excelforum.com/showthread...hreadid=272980



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

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
spreadsheet that add up to a particular total. Can someone help?


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

---
JuliaC's Profile:

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

http://www.excelforum.com/showthread...hreadid=272980


  #4   Report Post  
Old October 27th 04, 11:12 PM
Paul Corrado
 
Posts: n/a
Default

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





"JuliaC" wrote in message
...

Hello. I need to create a formula that will find the amounts on a
spreadsheet that add up to a particular total. Can someone help?


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

http://www.excelforum.com/member.php...o&userid=15790
View this thread: http://www.excelforum.com/showthread...hreadid=272980





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I create a formula to seperate name into two cells (last, . jobby55 Excel Discussion (Misc queries) 2 January 13th 05 05:00 AM
how can i create a formula or format the cells so the answer is a. jenniss Excel Discussion (Misc queries) 5 January 6th 05 04:50 PM
create a chart with a formula anon Charts and Charting in Excel 1 December 15th 04 08:55 PM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM
How can I create formula that turns a date into the week # in don Excel Discussion (Misc queries) 0 November 28th 04 09:21 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017