software

I have 2 cells containing a number, A1 (1) and B1 (10)

What i want is that it makes a sum of all the numbers from 1 to 10.
1 2 3 4 5 6 7 8 9 10 equals 55 and this is the result in C1

I'm not sure how to call this function, but i found something simular
on wikipedia:Code:
--------------------

If a sum has too many terms to write them all out individually, the sum may be written with an ellipsis
to mark out the missing terms.
Thus, the sum of all the natural numbers from 1 to 100 is 1 2 #8230; 99 100 = 5050.

Sums can be represented by the summation symbol, a capital Sigma. This is defined as:

\sum_{i=m}^n x_i = x_m x_{m 1} x_{m 2} \cdots x_{n-1} x_n.

--------------------

en.wikipedia.org/wiki/Summation#Notation--
Teebee
------------------------------------------------------------------------
Teebee's Profile: www.excelforum.com/member.php...oamp;userid=30353
View this thread: www.excelforum.com/showthread...hreadid=500100=SUM(ROW(INDIRECT(quot;dquot;amp;A1amp;quot;:dquot;amp;B1)))

Enter as Array formula, that is, commit with CTRL SHIFT ENTER instead of
just with ENTER

--
Kind regards,

Niek Otten

quot;Teebeequot; gt; wrote in
message ...
gt;
gt; I have 2 cells containing a number, A1 (1) and B1 (10)
gt;
gt; What i want is that it makes a sum of all the numbers from 1 to 10.
gt; 1 2 3 4 5 6 7 8 9 10 equals 55 and this is the result in C1
gt;
gt; I'm not sure how to call this function, but i found something simular
gt; on wikipedia:
gt;
gt;
gt; Code:
gt; --------------------
gt;
gt; If a sum has too many terms to write them all out individually, the sum
gt; may be written with an ellipsis
gt; to mark out the missing terms.
gt; Thus, the sum of all the natural numbers from 1 to 100 is 1 2 #8230;
gt; 99 100 = 5050.
gt;
gt; Sums can be represented by the summation symbol, a capital Sigma. This is
gt; defined as:
gt;
gt; \sum_{i=m}^n x_i = x_m x_{m 1} x_{m 2} \cdots x_{n-1} x_n.
gt;
gt; --------------------
gt;
gt; en.wikipedia.org/wiki/Summation#Notation
gt;
gt;
gt; --
gt; Teebee
gt; ------------------------------------------------------------------------
gt; Teebee's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30353
gt; View this thread: www.excelforum.com/showthread...hreadid=500100
gt;

Thx, that did the job.--
Teebee
------------------------------------------------------------------------
Teebee's Profile: www.excelforum.com/member.php...oamp;userid=30353
View this thread: www.excelforum.com/showthread...hreadid=500100Hi Niek,

what about
=(B1*(B1 1)-A1*(A1-1))/2

Regards,
Bernd