=SUMPRODUCT(LARGE(A1:A100,ROW(INDIRECT("2:100"))))
In a network with N nodes, what's the maximum number of connections you can make?Consider this:
eg N=2, gives 1 connection, N=3 gives 3, N=4 gives 6, N=5 gives 10, N=6 gives lots etc
I think it's sum of N-i from i=1 to N-1
How many when N=100?4,950
Can I simplify this in terms of N onlyYes. As above.
what's the function called in mathsPartial sum of integers
Just guessing it seems to be N choose 2, that googles to the right answer for 100
Is that right?