Mac,

Generalizing:

0: =COMBIN(21,0)*COMBIN(59,3)
1: =COMBIN(21,1)*COMBIN(59,2)
2: =COMBIN(21,2)*COMBIN(59,1)
3: =COMBIN(21,3)*COMBIN(59,0)

Starting to see the pattern?

HTH,
Bernie
MS Excel MVP

"mac_see" wrote in message
...
Confused again.......

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