| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a number within a range of numbers | Excel Worksheet Functions | |||
| Formula for finding matching numbers | New Users to Excel | |||
| formula for finding out the negative numbers | Excel Worksheet Functions | |||
| finding a number within a text and numbers for multiple rows | Excel Worksheet Functions | |||
| How do I prevent spicific visable cells from printing | Excel Discussion (Misc queries) | |||
Linear Mode
