Results 1 to 4 of 4

Thread: How to calculate combinations

  1. #1
    Acolyte Beddy Boy's Avatar
    Join Date
    Feb 2017
    Posts
    27
    Articles
    0
    Excel Version
    Excel 365

    How to calculate combinations



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I require a way to calculate the number of combinations of different numbers from 3 separate cells.

    For example:

    2,4
    10,14
    3,6,15

    The number of combinations here is 2x2x3 = 12

    I did use =SUM(LEN(B20)-LEN(SUBSTITUTE(B20,{1,2,3,4,5,6,7,8,9,0},))) but it takes a double figure number as 2 numbers.

    Any help would be appreciated.

    Thanks in advance!

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,364
    Articles
    0
    Excel Version
    Office 365 Subscription
    Try this instead:

    =SUM(LEN(A1)-LEN(SUBSTITUTE(A1,",","")))+1
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Acolyte Beddy Boy's Avatar
    Join Date
    Feb 2017
    Posts
    27
    Articles
    0
    Excel Version
    Excel 365
    Thank you Ali.. perfect!!

  4. #4
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    37
    Articles
    0
    Excel Version
    2016
    or
    =SUMPRODUCT((MID(B20,ROW($1:$99),1)=",")*1)+1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •