formula for finding numbers that add up to a spicific number

  • Thread starter Thread starter Aljar
  • Start date Start date
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

Macro to add numbers in a text string 5
Numbers in a column won't add up 1
Sum number range ignoring numbers formatted as text 0
How to make a number have a certain number of characters. 5
dividing a number up evenly into a year 3
How to determine the occurrence? 9
Excel How to add numbers in same cell? 2
Formula to add up numbers but there are negatives 3

Back
Top