Need help writing Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3084732%22%20slang%3D%22en-US%22%3ENeed%20help%20writing%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3084732%22%20slang%3D%22en-US%22%3E%3CP%3EHelp!%20I'm%20trying%20to%20write%20formula%20that%20shows%20all%20probabilities%20for%208%20numbers%20that%20totals%20%26lt%3B%3D23%20but%20can%20only%20use%205%20of%20the%208%20numbers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3084732%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085008%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20writing%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085008%22%20slang%3D%22en-US%22%3EAre%20the%208%20numbers%20given%3F%20Please%20provide%20more%20detailed%20information.%3C%2FLINGO-BODY%3E
New Contributor

Help! I'm trying to write formula that shows all probabilities for 8 numbers that totals <=23 but can only use 5 of the 8 numbers

3 Replies
Are the 8 numbers given? Please provide more detailed information.
I'm part of pool billiards team & I have 8 people on team that are all different skill levels ranging from1-9. I want to be able to have formula that calculates all combination possibilities made up of only 5 team members that <=23 total

@MandyJane 

See the attached sample workbook. It is a macro-enabled workbook, so you may have to allow macros when you open it.