Mac,

=COMBIN(59,3)
=21*COMBIN(59,2)
=59*COMBIN(21,2)
=COMBIN(21,3)
=COMBIN(80,3)

HTH,
Bernie
MS Excel MVP


I am clear on the combinations of 2 numbers. If we have to do the same
thing
with combinations of 3 numbers then?

Can you please replace all the "?" with data?

0 =COMBIN(59,2) 1711
1 =21*59 1239
2 =COMBIN(21,2) 210
------------------------------------------------------
TOTAL (=COMBIN(80,2) 3160
------------------------------------------------------

0 ? ?
1 ? ?
2 ? ?
3 =COMBIN(21,3) 1330
------------------------------------------------------
TOTAL (=COMBIN(80,2) 82160
------------------------------------------------------

"Bernie Deitrick" wrote:

Mac,

2) 21 numbers chosen, 59 not chosen, so each could be paired with any,
for a
total of

=21*59

or the 1239 that you calc'd.

3) 59 numbers not chosen, means:

=COMBIN(59,2)

will give the 1711

HTH,
Bernie
MS Excel MVP