LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default EXCEL FIND A SPECIFIC TOTAL

Is there a formula or look up function within excel that will do the following:

Locate within a range of cells the cells that when summed together equal a
specified amount.

For example: I am looking for 22,000 amount that is a combination of the
records within a range of cells.

Will excel show me the possible results even if it were many?

Help and thanks.
 
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
Find the Total of Alphabits in Excel Ramya Jois Excel Discussion (Misc queries) 3 January 28th 09 09:13 AM
What function will find and multiply specific values in excel? paul/bones Excel Worksheet Functions 1 March 20th 07 09:44 PM
Can excel find a sequence of numbers from a known total? efandango Excel Discussion (Misc queries) 16 February 15th 07 11:40 PM
Can excel find a sequence of numbers from a known total? efandango Excel Worksheet Functions 16 February 15th 07 11:40 PM
How do i total cells in excel that contain specific text? Zurbs17 Excel Discussion (Misc queries) 4 March 25th 06 01:49 AM


All times are GMT +1. The time now is 04:56 PM.

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

About Us

"It's about Microsoft Excel"