ExcelBanter - Excel:I have15 #'s that total $65,000...which #'s make up $44,000

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel:I have15 #'s that total $65,000...which #'s make up $44,000 (https://www.excelbanter.com/excel-worksheet-functions/79216-excel-i-have15-s-total-%2465-000-s-make-up-%2444-000-a.html)

Kelly

Excel:I have15 #'s that total $65,000...which #'s make up $44,000

I have a large column of numbers that totals $110,555. I need to find out
which numbers total approximately $57,622. Is there a function that can take
a range and select items that total a specific number in the range?

Duke Carey

Excel:I have15 #'s that total $65,000...which #'s make up $44,000

See this explanation from a few days ago by B. R. Ramachandran

http://groups.google.com/group/micro...eeace873b464ae

"Kelly" wrote:

I have a large column of numbers that totals $110,555. I need to find out
which numbers total approximately $57,622. Is there a function that can take
a range and select items that total a specific number in the range?

All times are GMT +1. The time now is 01:12 AM.