ExcelBanter - formula for finding numbers that add up to a spicific number

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula for finding numbers that add up to a spicific number (https://www.excelbanter.com/excel-discussion-misc-queries/262631-formula-finding-numbers-add-up-spicific-number.html)

Aljar

formula for finding numbers that add up to a spicific number

I have a cloumn of numbers. I need a formula that will select 4 of these
numbers that add up to a known number.
example:
column C has the following numbers 4, 8, 12, 6, 21, 28, 17, 20, 24
I need to for of these numbers that add up to 50
What formula can I use?
--
Aljar

Eduardo

formula for finding numbers that add up to a spicific number

Hi,
Look here

http://www.tushar-mehta.com/excel/te...ues/index.html

"Aljar" wrote:

I have a cloumn of numbers. I need a formula that will select 4 of these
numbers that add up to a known number.
example:
column C has the following numbers 4, 8, 12, 6, 21, 28, 17, 20, 24
I need to for of these numbers that add up to 50
What formula can I use?
--
Aljar

AlBear

1 Attachment(s)

Quote:

Originally Posted by Aljar (Post 949567)

You could use SumMatch from SumMatch.com, is a low cost Excel Add in that is used by Auditors and Accountants

All times are GMT +1. The time now is 02:42 PM.