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: 1
Default Find terms that sum to chosen total among a column of numbers?

Can you highlight a column of numbers and tell excel to find those numbers in
the column that sum to a number that you choose? And if there are no numbers
in the column that sum to that given total, it will indicate such?
 
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 to find a special total from a combination of numbers Zima Excel Worksheet Functions 4 May 7th 07 05:02 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
find numbers in a list which sum a total LINDA Excel Worksheet Functions 1 September 22nd 06 02:06 PM
find text in column h and total the corresponding numbers if colum adelaide Excel Discussion (Misc queries) 2 February 6th 06 04:47 AM


All times are GMT +1. The time now is 03:25 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"