I am new at forums and excel. My question:
I have the numbers 1-49. Every time choose 7 numbers from the 49 numbers that will add up to 124. All these sets of 7 numbers must be displayed or be printed.
Yhankyou

Hi
this is a well known and documented problem.
I Googled "which numbers add up to my target number excel" and got 9Mio+ answers.

I'll leave it up to you to pick your preferred solution.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post