# 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

fast! Ԝhat web host are уou the usage of?