formula for finding numbers that add up to a spicific number

A

Aljar

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers in a column won't add up 1
Macro to add numbers in a text string 5
Formula to add up numbers but there are negatives 3
How to determine the occurrence? 9
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
How to make a number have a certain number of characters. 5
Formula 3
Numbers in a formula! 4

Top