How to calculate lottery combinations by sums

[motilulla]

Hello,

Is there any way to calculate sum combinations?

Simple for example 6/49 lottery total combinations 13.983.816
Using all 49 numbers….
Minimum sum 1+2+3+4+5+6 = 21 (1 combination)
Maximum sum 44+45+46+47+48+49= 279 (1 combination)
Question-1 how much combinations will be find with each sum from 21 to 279

Now for example we fix in position number “1” this bring down combinations to 1.712.304
Question-2 what will be the min maximum sum range and how many and combinations will be find with each sum

Now for example we fix in position number “2” this bring down combinations to 1.533.939
Question-3 what will be the min maximum sum range and how many and combinations will be find with each sum

Please advice does exist any VBA of Formula to work out sums

Thanks In Advance
Using version 2000

Regards,
Moti

 

[ststern45]

Stephen your work is fantastic and extremely fast. Hats off!!

 

[StephenCrump]

I'm glad you're finding it useful. Thanks for posting!