Thanx GillesD for the quick learn how on Excell with regards to combinations. I would also like to know if there are any possible formulas that I could use to eliminate runs of 3 or more in all sum range combinations. Example all 165,772 combo's within the sum range of 150 less the combinations with runs of 3 consecutive numbers or more. I would like to eliminate combo's of 6 with numbers in them like 23,24,25 ect....... or combo's with all even or odd numbers. Could Excell create such beauty????? This would reduce the total of combo's considerably in each sum range I'm sure. I do not want to modify the formulas you have already posted, I will ruin them for sure. I hope my questions are clear enough. You Probably undersatnd my questions better then I do!!! I'm so AMAZED with what you've already opened my eyes to with Excell that I'm completely hooked. I think I've already asked enough that you should be charging me a fee already!!!!