Combin Array?

In cells A1:C1 I have the numbers 8, 3, and 5. In cell D1 I would like to automatically sum the number of combinations like so:

=COMBIN($A1,3)+COMBIN($A1,4)+COMBIN($A1,5)

If C1 was 6 instead of 5, then I would want:

=COMBIN($A1,3)+COMBIN($A1,4)+COMBIN($A1,5)+COMBIN($A1,6)

If C1 was instead 1, then I would want:

=COMBIN($A1,3)+COMBIN($A1,2)+COMBIN($A1,1)

So in other words, I’d like B1 to be the target number of samples that C1 heads towards in the D1 formula.

By: Smock Yaba

2,158 thoughts on “Combin Array?

  1. 출장마사지

    Terrific work! This is the type of info that should be shared across the web. Disgrace on Google for no longer positioning this put up higher! Come on over and discuss with my web site. Thank you =)

  2. healthy fresh recipes

    Good post. I learn something new and challenging on blogs I stumbleupon on a daily basis. It will always be interesting to read content from other writers and practice a little something from their sites.

  3. genolyze

    I’m impressed, I have to admit. Seldom do I come across a blog that’s both equally educative and amusing, and let me tell you, you have hit the nail on the head. The issue is something that too few folks are speaking intelligently about. Now i’m very happy that I stumbled across this in my hunt for something regarding this.

  4. dominoqq

    Excellent blog right here! Additionally your website ѕo mսch սp
    fast! Ԝhat web host are уou the usage of?

    Cɑn I get your associate link fߋr yоur host?
    Ӏ desire mʏ site loaded up as fɑst as yours lol

  5. Tabitha

    Thanks for sharing your info. I really appreciate your efforts
    and I am waiting for your next write ups thanks once again.

  6. eyfas.com

    Spot on with this write-up, I truly believe this site needs much more attention. I’ll probably be back again to read through more, thanks for the advice!

Comments are closed.