On 2002-03-20 15:10, Jay Petrulis wrote:

Hi Abdc,

If the value cannot be obtained, that is equivalent to COMBIN(x,0), which is always 1, so change

{ =SUM(COMBIN(20,ROW(1:20))) }

= 1,048,575

to

{ =1+SUM(COMBIN(20,ROW(1:20))) }

=1,048,576

Just an exercise, as your point is very good.

Can anybody help to generalize this by making a reference to a cell rather than hardcoding the 20 in the formula?

This doesn't work (G1 is the reference cell)

=1+SUM(COMBIN(G1,INDIRECT("ROW(1:"&G1&")")))

array entered.

Any help greatly appreciated.

Thanks,

Jay

## Like this thread? Share it with others